topic Re: Days count in QlikView

Days count

sunilkumarqv — Wed, 26 Nov 2014 04:30:43 GMT

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.

tresB — Wed, 26 Nov 2014 04:55:30 GMT

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

sujeetsingh — Wed, 26 Nov 2014 04:58:22 GMT

It is quite confusing

You can use interval function

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

PrashantSangle — Wed, 26 Nov 2014 05:00:14 GMT

Hi,

Try like

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

Regards

amit_saini — Wed, 26 Nov 2014 05:04:21 GMT

Sunil,

Try this:

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

Thanks,
AS