Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
qliktech_uk
Contributor III
Contributor III

Reporting on a calendar dimension.

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.

1 Solution

Accepted Solutions
prieper
Master II
Master II

This depends a bit on your datamodel and the requirements towards the application.

Think that your approach is the appropriate one and should work.

View solution in original post

3 Replies
prieper
Master II
Master II

This depends a bit on your datamodel and the requirements towards the application.

Think that your approach is the appropriate one and should work.

View solution in original post

qliktech_uk
Contributor III
Contributor III
Author

Thanks for your reply Peter, are there any other options as well, just curious to know the available options.

prieper
Master II
Master II

You may create a kind of a common calendar, e.g. you may select May 2017 and you would see then all date-entries (be it first connected or last connected) falling into May.