3 Replies Latest reply: Sep 18, 2017 6:02 AM by Peter Rieper RSS

    Reporting on a calendar dimension.

    qlik tech



      I have a scenario where I have 2 tables, one for device sent  and one for device connected, the connected table has got 2 fields to determine when it was connected, a first connect time and a last connect time.


      If I derive the date from the time and join this to 2 calendar tables (alias the calendar table one for last connect and other for last connect) I should be able to get the data for total sent and connected by selecting the appropriate calendar dimensions?


      Is this the best way of design ?