Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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!

Tags (2)
1 Solution

Accepted Solutions
chandashok
Contributor III

Re: Count number of date

Hi

     Hope the attached file will be helpful for your doubt

Regards

Ashok

4 Replies
deepakk
Valued Contributor III

Count number of date

hi,

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

MVP
MVP

Count number of date

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.

chandashok
Contributor III

Re: Count number of date

Hi

     Hope the attached file will be helpful for your doubt

Regards

Ashok

Not applicable

Count number of date

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

Community Browser