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

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...