topic How do you do a % of use based on dates ? in QlikView https://community.qlik.com/t5/QlikView/How-do-you-do-a-of-use-based-on-dates/m-p/619334#M1101507 <HTML><HEAD></HEAD><BODY><P>In the document attached, you can see a list of tourism cards usage for a city. </P><P></P><P>For example, card number <STRONG>240250</STRONG> is a 24hours card and has been used during <SPAN style="text-decoration: underline;">1 day only</SPAN>, first time at 13:21 and second time at 15:34 during the 22nd of the month.</P><P></P><P>What I need to do is to see whether this 24h card, is used during 1 day only (like in my example card id <STRONG>240250</STRONG>) or over 2 days, like the card number <STRONG>2402518</STRONG></P><P><STRONG><BR /></STRONG></P><P>I do no know what would be the best representation for that kind of information ??, knowing that&nbsp; I need to do this exercice for also 48h and 72h cards ?</P><P></P><P>example attached for a possible representation.</P><P>thanks for your help</P><P><STRONG><BR /></STRONG></P><P><STRONG> </STRONG></P></BODY></HTML> Wed, 09 Apr 2014 12:32:14 GMT 2014-04-09T12:32:14Z How do you do a % of use based on dates ? https://community.qlik.com/t5/QlikView/How-do-you-do-a-of-use-based-on-dates/m-p/619334#M1101507 <HTML><HEAD></HEAD><BODY><P>In the document attached, you can see a list of tourism cards usage for a city. </P><P></P><P>For example, card number <STRONG>240250</STRONG> is a 24hours card and has been used during <SPAN style="text-decoration: underline;">1 day only</SPAN>, first time at 13:21 and second time at 15:34 during the 22nd of the month.</P><P></P><P>What I need to do is to see whether this 24h card, is used during 1 day only (like in my example card id <STRONG>240250</STRONG>) or over 2 days, like the card number <STRONG>2402518</STRONG></P><P><STRONG><BR /></STRONG></P><P>I do no know what would be the best representation for that kind of information ??, knowing that&nbsp; I need to do this exercice for also 48h and 72h cards ?</P><P></P><P>example attached for a possible representation.</P><P>thanks for your help</P><P><STRONG><BR /></STRONG></P><P><STRONG> </STRONG></P></BODY></HTML> Wed, 09 Apr 2014 12:32:14 GMT https://community.qlik.com/t5/QlikView/How-do-you-do-a-of-use-based-on-dates/m-p/619334#M1101507 2014-04-09T12:32:14Z