topic Re: Set Analysis + Pass strings in QlikView

Set Analysis + Pass strings

Anonymous — Fri, 15 Jul 2016 11:31:38 GMT

Hi,

In the Dashboard I have a multi box which has following values

now based on the selection I need to pass value to set analysis expression

Lets Say if I select A and B then the expression should be

=Sum({<ColumnValue={'A','B'}>} Amount)

if I select A ,B and C then the expression should be

=Sum({<ColumnValue={'A','B','C'}>} Amount)

Re: Set Analysis + Pass strings

Gysbert_Wassenaar — Fri, 15 Jul 2016 11:36:22 GMT

If the field in the multibox is ColumnValue then you don't need any set modifier. sum(Amount) will do what you want. If it's a different field then use =Sum({<ColumnValue=P(MultiBoxFieldHere)>} Amount) and replace MultiBoxFieldHere with the name of the field in the multibox. And it has to be a field, expression do not work.

Re: Set Analysis + Pass strings

tresB — Fri, 15 Jul 2016 11:37:08 GMT

That is same as simple = Sum(Amount) // only the selected values would be considered, isn't it?

Re: Set Analysis + Pass strings

abhijain — Fri, 15 Jul 2016 12:00:12 GMT

Hi Manoj,

Create 1 variable eg

v_var = getfieldselections(ColumnName,',')

and use this expression in chart

sum({$<ColumnName={$(v_var)}>}Amount)