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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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