Discussion Board for collaboration related to Creating Analytics for QlikView.
I've problem in counting number of days
if i have table with data like this:
how to count number of days from today to 'Date'?
I want to count how many days from data 'Date' to today date. any idea?
thanks for your help all!
Go to Solution.
Hope the attached file will be helpful for your doubt
If I am correct. (today() - Date) as Days will give you the required output.
Use the following Load script to arrive the difference between Today and Date
Interval(today() - Date, 'D') as Days
Hope this helps you.
thanks chandashok, jagan, and deepak. its working now! thanks!