Compare fields in set analysis

Mon, 26 Oct 2009 12:28:27 GMT

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

Compare fields in set analysis

Mon, 26 Oct 2009 17:10:22 GMT

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!

topic Compare fields in set analysis in QlikView

Compare fields in set analysis

Compare fields in set analysis