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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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