topic Re: Set Analysis Selection in QlikView

Set Analysis Selection

Anonymous — Wed, 10 Jul 2013 15:02:59 GMT

I know how to use Set Analysis in chart expressions, but how do you use Set Analysis to make selections using a Button Object Action (e.g., Select in Field)?

Re: Set Analysis Selection

tresB — Wed, 10 Jul 2013 17:32:51 GMT

Set analysis is used in aggregation functions and to trigger a selection you have to pass a string (Search String) that you can do like :

=Chr(39)&'('& Concat({1} DISTINCT Year, '|') &')'&chr(39)

Here i have taken Year's(a field) all values to be selected irrespective of the existing selection.

i. e, you have to use aggregation functions(Concat, Only ...) i believe.

Re: Set Analysis Selection

Anonymous — Thu, 11 Jul 2013 13:13:22 GMT

Thanks. It pointed me in the right direction, I wound up using:

=if($(vLimitSales)<>1,'(' & concat({$< Component = {"=aggr(sum(Sales_Value),Component) <$(#=vMaxSales*1000)"}>} Component, '|') & ')')

Just out of curiosity, what's the purpose of bracketing the expression with the ASCII single quotes, Chr(39)? I didn't need them.