FRENContact us

Tips and field notes

Tips, field notes and best practices on Qlik, Talend and Snowflake from the HeyData experts.

  1. The foundations of a Talend project: principles, guidelines and conventions
  1. Aggr() in Qlik Sense: the virtual table and its four pitfalls
  2. Advanced set analysis in Qlik Sense: P(), E(), operators and searches
  3. Dollar-sign expansion in Qlik Sense: $(var), $(=…), $(#…) and parameters
  4. Above, Below, RangeSum: inter-record functions in Qlik Sense charts
  5. Window() in Qlik Sense: averages, running totals and sliding windows in the script
  6. CrossTable in Qlik Sense: unpivoting a cross table at load time
  7. The Generic prefix in Qlik Sense: from attribute-value data to dimensions
  8. The Semantic prefix in Qlik Sense: moving from parent to child in one click
  9. Merge, Add, Replace: partial reload in Qlik Sense
  10. Dual() and the dual nature of values in Qlik Sense
  11. FirstSortedValue, Concat, Only, Rank: lesser-known Qlik Sense aggregations
  12. ValueLoop and ValueList: synthetic dimensions in Qlik Sense
  13. Class, Match, WildMatch, Pick: banding and mapping without a lookup table
  1. Joins and lookups in Qlik Sense: when to link, when to join
  2. NULL, zero, empty string: handling missing values in Qlik Sense
  3. Generic keys in Qlik Sense: linking data that do not share the same granularity
  4. Generating missing data in Qlik Sense
  5. IntervalMatch and slowly changing dimensions in Qlik Sense
  6. Hierarchies in Qlik Sense: from parent-child table to access rights
  7. Incremental load with QVD files in Qlik Sense: the three cases