Qlik Sense 2.2 - Preparing Data - Part 2

    Adding data to Qlik Sense is very easy, however Qlik Sense does not know your data until you allow it to prepare it for use within the app. There are a few ways to prepare data with Qlik Sense. This video is part 2 of a two part series, which demonstrates an 'advanced' approach when adding data to a Qlik Sense app. This video shows you what happens when you select 'Prepare Data'. Samples and the video .mp4 file are attached below.

     

     

    Part 1: Qlik Sense 2.2 - Preparing Data - Part 1

     

    NOTE: You can use the expanded date dimension functionality with existing apps prior to 2.2, buy using the DECLARE and DERIVE expressions in your Data Load script.

     

    Example:

    [autoCalendar]:

      DECLARE FIELD DEFINITION Tagged ('$date')

    FIELDS

      Dual(Year($1), YearStart($1)) AS [Year] Tagged ('$axis', '$year'),

      Dual('Q'&Num(Ceil(Num(Month($1))/3)),Num(Ceil(NUM(Month($1))/3),00)) AS [Quarter] Tagged ('$quarter'),

      Dual(Year($1)&'-Q'&Num(Ceil(Num(Month($1))/3)),QuarterStart($1)) AS [YearQuarter] Tagged ('$axis', '$yearquarter'),

      Month($1) AS [Month] Tagged ('$month'),

      Dual(Year($1)&'-'&Month($1), monthstart($1)) AS [YearMonth] Tagged ('$axis', '$yearmonth'),

      Dual('W'&Num(Week($1),00), Num(Week($1),00)) AS [Week] Tagged ('$weeknumber'),

      Date(Floor($1)) AS [Date] Tagged ('$date');

     

    DERIVE FIELDS FROM FIELDS [OrderDate] USING [autoCalendar] ;

     

    http://help.qlik.com/en-US/sense/2.2/Subsystems/Hub/Content/Scripting/ScriptRegularStatements/Declare.htm?q=declare

     

    Derived fields ‒ Qlik Sense