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

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
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

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


talk is cheap, supply exceeds demand