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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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

1 Reply
Not applicable
Author

It's not really clear, but I think this is the wrong part:

[Project Completion Date]={">=$(=[Project Due Date])"}

If I understand correctly, you use a dollar sign expansion without reason, IMO.

It should be [Project Completion Date]={"=([Project Completion Date]>=[Project Due Date])"}

This (should) select the rows having PCD greater than PDD.

Hope it helps!