topic Re: Difference between two dates using setnalysis in QlikView

Difference between two dates using setnalysis

Tue, 28 Jan 2014 11:11:18 GMT

Hi,

I have a requirement wherein I need to calculate the difference between two dates and must include the following filters when calculating the same flag=1,Div=’abc’,month=,day=, and year =,

When I use the below expression

Round(date(startdate,’DD/MM/YYYY’)-date(enddate,’DD/MM/YYYY’))

Appling set analysis to include the above mentioned filters is not possible.So can anyone please let me know how I could apply the filters using set analysis to the above mentioned expression

Thanks & Regards,

Smitha

Re: Difference between two dates using setnalysis

MK_QSL — Tue, 28 Jan 2014 11:15:15 GMT

can you enclosed your sample apps?

Re: Difference between two dates using setnalysis

Tue, 28 Jan 2014 11:22:34 GMT

Try to use Only({<flag={1},Div={abc},month=,day=,year=>}Round(date(startdate,’DD/MM/YYYY’)-date(enddate,’DD/MM/YYYY’)))

Thanks,

Selva