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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
orangebloss
Creator
Creator

Ignoring all filters in set analysis

I need a static KPI that doesn't change when any filters are used throughout my app,

 

reading around it looks like the key is using {1} but I'm evidently not getting it in the right place as it's not working!

 

Current format is as below which returns a null when a filter is selected:

1-

((Sum({1}{$<TdateYear={"(=$(vCurrentYear))"},NPD_Other={'Overhead'}>} Nmhrs))+ (Sum({1}{$<TdateYear={"(=$(vCurrentYear))"},NPD_Other={'Overhead'}>} OThrs)))/

((Sum({1}{$<TdateYear={"(=$(vCurrentYear))"}>} Nmhrs))+ (Sum({1}{$<TdateYear={"(=$(vCurrentYear))"}>} OThrs)))

Labels (2)
11 Replies
orangebloss
Creator
Creator
Author

Thanks Marcus - why would the rangesum give me a different result to my original total ? 

 

marcus_sommer

By combining values with the normal math operators each non-numeric result for one of them will produce NULL for the entire calculation-level. The range-functions instead handle each non-numeric parameter as ZERO. Within the most scenarios is this type of error/exception-handling more suitable and expedient as getting NULL.