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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis : to use a predefined value ignoring value selected though multibox.

sum({1<Version={'1.1'},Product={'alpha'}>} orders)

This when added in a graph or straight table, gives correct value only
when version 1.1 and product alpha is selected in multibox.

However I want this value to remaining unchanged irrespective of the values selected in the multibox for version and product.

What is wrong with my current set analysis?

I also need to add Max and aggr function to it

max(aggr(sum({1<Version={'1.1'},Project={'alpha'}>} orders),dim1s,dim1a))

dim1s and dim1a are not in multibox so we dont have the problem of selection for them.

1 Reply
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

This set analysis condition should produce correct results if everything is spelled correctly. Try the same without single quotes for the Version field (in case the version is a numeric field). Other than that, i t should work. You can try and post a simplified example here, and someone could try to troubleshoot it...

Ask me about Qlik Sense Expert Class!