Qlik Community

Qlik Sense Enterprise Documents

Documents for Qlik Sense related information.

Time Aware Charts

Employee
Employee

Time Aware Charts

This video shows you how to use a time-aware chart, available in Qlik Sense 3.0. Sample data is below. Note that it is important for you to click the Prepare Data button when adding data to the app. This is initiates the auto-calendar process within the data load.

NOTE: To increase resolution or size of the video, select the YouTube logo in the bottom right of the player. You will be brought directly to YouTube where you can increase the resolution and size of the player window. Look for the 'settings' gears icon in the lower right of the player once at YouTube.

Comments
uzername
New Contributor III

Hi I'm trying to replicate this on desktop 3.1 (exact same steps) but it would not generate these visuals in the end, just normal line chart. , what am I missing? (I have tried both raw and date cast OrderDate).

Regards,

Mario

auto-gen load script below:

[Orders$]:

LOAD

  [OrderID],

  Date(Date#([OrderDate], 'M/DD/YYYY') ) AS [OrderDate],

  [CustomerID],

  [EmployeeID],

  [ShipperID],

  [ProductID],

  [Sales],

  [COS],

  [GP],

  [Quantity],

  [Discount],

  [Freight],

  [StatusID]

FROM [lib://Downloads/smart_orders.xls]

(biff, embedded labels, table is Orders$);

[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', '$cyclic'),

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

  Dual('Q'&Num(Ceil(Num(Month($1))/3)),QuarterStart($1)) AS [_YearQuarter] Tagged ('$yearquarter', '$hidden', '$simplified'),

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

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

  Dual(Month($1), monthstart($1)) AS [_YearMonth] Tagged ('$axis', '$yearmonth', '$simplified', '$hidden'),

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

  Date(Floor($1)) AS [Date] Tagged ('$axis', '$date', '$qualified'),

  Date(Floor($1), 'D') AS [_Date] Tagged ('$axis', '$date', '$hidden', '$simplified');

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

Employee
Employee

Hello - let me take a look for you.

I am speculating here - but take a look at what I found.

OK - there is one more step you must go through - I just tested this and got the same results as you - I am suspect that - the orderdate field in your list looks like this when you are using it in the chart, therefore not making it look like a time-aware chart as in the video.

1-

When it should look like this in the list (with the dimensions)

2-

This structure is how you know when your date fields have auto-generated the date dimensions.

I discuss this here at this time-code (1:25) in the video: Qlik Sense 3.0 - Time-aware Charts - YouTube

You need to "prepare data" or go into the data manager, and then load the data from that interface - it should then generate the date dimensions in the list.

Then you can drag the top level orderdate field on the chart - or use it as the dimension:

let me know how you do.

Please open up discussion threads in this New to Qlik Sense forum for further questions so the entire community can help you. Otherwise only the author of the post and those who commented will only see your comment.

Stay well

Mike Tarallo

Qlik

uzername
New Contributor III

Thanks Mike.

Version history
Revision #:
1 of 1
Last update:
‎06-21-2016 10:57 AM
Updated by:
Employee