Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do you do a % of use based on dates ?

In the document attached, you can see a list of tourism cards usage for a city.

For example, card number 240250 is a 24hours card and has been used during 1 day only, first time at 13:21 and second time at 15:34 during the 22nd of the month.

What I need to do is to see whether this 24h card, is used during 1 day only (like in my example card id 240250) or over 2 days, like the card number 2402518


I do no know what would be the best representation for that kind of information ??, knowing that  I need to do this exercice for also 48h and 72h cards ?

example attached for a possible representation.

thanks for your help


0 Replies