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

Count number of date

hi all,

I've problem in counting number of days

if i have table with data like this:

Date

1/1/2011

12/1/2011

12/12/2010

2/2/2012

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!

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi

     Hope the attached file will be helpful for your doubt

Regards

Ashok

View solution in original post

4 Replies
deepakk
Partner - Specialist III
Partner - Specialist III

hi,

If I am correct. (today() - Date) as Days will give you the required output.

jagan
Partner - Champion III
Partner - Champion III

Hi,

Use the following Load script to arrive the difference between Today and Date

LOAD

     Date,

     Interval(today() - Date, 'D') as Days

FROM DataSource;

Hope this helps you.

Regarsd,

Jagan.

Anonymous
Not applicable
Author

Hi

     Hope the attached file will be helpful for your doubt

Regards

Ashok

Not applicable
Author

thanks chandashok, jagan, and deepak. its working now! thanks!