topic Date Difference in QlikView

Date Difference

Fri, 18 Jul 2014 06:15:56 GMT

I have a scenario , where my i have to find the ddifference between the STATEMENT DATE , for NICK NAME and the condition is

Period Type = 'Year End'

Please find the attached excel of sample data

Re: Date Difference

sujeetsingh — Fri, 18 Jul 2014 06:20:06 GMT

It will be as

if(Period Type = 'Year End',Interval(STATEMENT DATE-STATEMENT DATE2,'dd') as DifferenceTime

Re: Date Difference

PradeepReddy — Fri, 18 Jul 2014 06:42:36 GMT

If are you going to showcase the data in table format?, then take a pivot table...

Dimension : Nick Name

Expression: Max({<Period Type ={'Year End'}>STMT_DT)-Min({<Period Type ={'Year End'}>STMT_DT)

Re: Date Difference

jagan — Fri, 18 Jul 2014 06:44:47 GMT

Hi,

Try Interval() like this

=Interval(YearEnd([STATEMENT DATE]) - [STATEMENT DATE], 'DD') for getting the difference between the STATEMENT DATE AND Year end, if you want current year end then use below expression

=Interval(YearEnd(Today()) - [STATEMENT DATE], 'DD')

Regards,

Jagan.

Re: Date Difference

SunilChauhan — Fri, 18 Jul 2014 06:46:19 GMT

which two date you want to make difference

if(Period Type = 'Year End',Interval(DATEfeidl1-Datefield2,'dd')