Discussion Board for collaboration on QlikView Scripting.
Situation is I want to calculate the no. of days a person been actively using a service. Based on a customers earliest period (date) of using the service till the current date of their usage, I would like to compute the no. of days.
Any idea on how to do so? Sample script?
Please advise. Thank you.
Go to Solution.
Take a straight table; Customer as dimension; expression, something like: Max(Date)-Min(Date)
It all depends on your data, how your records are being stored.
If you have 2 dates and you need to compute N° of days between them, simply
Num(Date2) - Num(Date1) gives you the number of days
Note: Change according to your usage.
That just doesn't make any sense to me.
Thanks once again tres! Your a legend.