Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

sunilkumarqv
Valued Contributor II

Days count

Hi,

I need days bw months for example.

Date,             Days

31/03/2013   , 30

30/04/2013  , 31

31/05/2013  , 30

Need to automate this in script  like in Days Column.

1 Solution

Accepted Solutions
sujeetsingh
Honored Contributor III

Re: Days count

It is quite confusing

You can use interval function

Interval(Date1-Date2,'dd') as Days

4 Replies
MVP
MVP

Re: Days count

Could you explain a bit more about the logic of output and your data?

sujeetsingh
Honored Contributor III

Re: Days count

It is quite confusing

You can use interval function

Interval(Date1-Date2,'dd') as Days

Re: Days count

Hi,

Try like

Interval(date-previous(date),'D')

Regards

Regards,
Prashant Sangle
amit_saini
Honored Contributor III

Re: Days count

Sunil,

Try this:

Interval(Today()-Date(Date#(Date_Field,'DD/MM/YYYY')),'dd')  as NoOfDays,

Thanks,
AS

Community Browser