topic Set analysis : to use a predefined value ignoring value selected though multibox. in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-to-use-a-predefined-value-ignoring-value-selected/m-p/236164#M87376 <HTML><HEAD></HEAD><BODY><P>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...</P></BODY></HTML> Sat, 30 Apr 2011 21:29:57 GMT Oleg_Troyansky 2011-04-30T21:29:57Z Set analysis : to use a predefined value ignoring value selected though multibox. https://community.qlik.com/t5/QlikView/Set-analysis-to-use-a-predefined-value-ignoring-value-selected/m-p/236163#M87375 <HTML><HEAD></HEAD><BODY><P>sum({1&lt;Version={'1.1'},Product={'alpha'}&gt;} orders)<BR /><BR />This when added in a graph or straight table, gives correct value only<BR />when version 1.1 and product alpha is selected in multibox.<BR /><BR />However I want this value to remaining unchanged irrespective of the values selected in the multibox for version and product.<BR /><BR />What is wrong with my current set analysis?</P><P></P><P>I also need to add Max and aggr function to it</P><P>max(aggr(sum({1&lt;Version={'1.1'},Project={'alpha'}&gt;} orders),dim1s,dim1a))</P><P></P><P>dim1s and dim1a are not in multibox so we dont have the problem of selection for them.</P><P></P><P></P></BODY></HTML> Sat, 30 Apr 2011 20:34:50 GMT https://community.qlik.com/t5/QlikView/Set-analysis-to-use-a-predefined-value-ignoring-value-selected/m-p/236163#M87375 2011-04-30T20:34:50Z Set analysis : to use a predefined value ignoring value selected though multibox. https://community.qlik.com/t5/QlikView/Set-analysis-to-use-a-predefined-value-ignoring-value-selected/m-p/236164#M87376 <HTML><HEAD></HEAD><BODY><P>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...</P></BODY></HTML> Sat, 30 Apr 2011 21:29:57 GMT https://community.qlik.com/t5/QlikView/Set-analysis-to-use-a-predefined-value-ignoring-value-selected/m-p/236164#M87376 Oleg_Troyansky 2011-04-30T21:29:57Z