Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can I do comparison of two fields with my set analysis?


I get the notification   "Error in set modifier expression"    for the expression below.  I am trying to get a count for Work Orders where the Closed date is on or before the required completeion date.

 

count({$<[WO Close Date.CalendarMonthNum] <= [WO Required Date.CalendarMonthNum], [WO Responsible Planner]= {'Hartsfield*'},[Asset ID] ={'PS-*'}>} distinct [WO ID]

)

5 Replies
Not applicable
Author

Try something like this:

count({$<[WO Close Date.CalendarMonthNum] = {"=[WO Close Date.CalendarMonthNum]<=[WO Required Date.CalendarMonthNum]"}, [WO Responsible Planner]= {'Hartsfield*'},[Asset ID] ={'PS-*'}>} distinct [WO ID])

Gysbert_Wassenaar

or even:

count({$<[WO Close Date.CalendarMonthNum] = {"<=[WO Required Date.CalendarMonthNum]"}, [WO Responsible Planner]= {'Hartsfield*'},[Asset ID] ={'PS-*'}>} distinct [WO ID])


talk is cheap, supply exceeds demand
Not applicable
Author

The syntax is correct.  I am not getting an error now.  However,  this set analysis is not retrieving any data.  Thanks for your help.

Not applicable
Author

Thanks for your help Gysbert.  The error is gone.  However, there is still no data being retrieved with this set analysis.

Gysbert_Wassenaar

It needs a value selected in field [WO Required Date.CalendarMonthNum] to work.


talk is cheap, supply exceeds demand