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

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

Compare fields in set analysis

Hello All,

I have 2 fields in my table : Project Completion Date and Project due date. Now I need sum of all rows for which the Project completion date > project due date. I tried using the following set analysis but it didnt work.

=Sum({1<[PPO Indicator] = {Close},[Project Status] = {Completed},[Project Completion Date]={">=$(=[Project Due Date])"} >}[Value])

The user does not select any values in these fields.

Thanks

Arun



0 Replies