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

    Reporting on a calendar dimension.

    qlik tech

      Hi

       

      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 ?

       

      Thanks.