Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Difference between two dates using setnalysis

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

2 Replies
MK_QSL
MVP
MVP

can you enclosed your sample apps?

Not applicable
Author

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

Thanks,

Selva