topic Variable in Setanalysis. in QlikView

Variable in Setanalysis.

warrentk80 — Tue, 13 Sep 2016 08:40:29 GMT

Hello everyone, I need to use a variable in setanalysis.

the variable is called var_seriemax and must be set in series

I tried this string but the syntax is incorrect
= Sum ({$ <[number] = {} v_seriemax, AnnoSerie = {'2016'}>} [Budget €] / 1000000)

You would know someone show me how to do?

Thanks for collaboration

Andrew

Re: Variable in Setanalysis.

trdandamudi — Tue, 13 Sep 2016 08:46:31 GMT

May be as below:

= Sum ({$ <[number] = {'$(v_seriemax)'}, AnnoSerie = {'2016'}>} [Budget €] / 1000000)

Note: Assuming your variable name is v_seriemax.

Re: Variable in Setanalysis.

swuehl — Tue, 13 Sep 2016 08:46:36 GMT

Not sure what you mean with 'must be set in series', try a dollar sign expansion in a set modifier like

= Sum ({$ <[number] = {'$(v_seriemax)'}, AnnoSerie = {'2016'}>} [Budget €] / 1000000)

Re: Variable in Setanalysis.

Anonymous — Tue, 13 Sep 2016 08:53:40 GMT

= (Sum ({$ <[number] = {‘$(v_seriemax)’}, AnnoSerie = {'2016'}>} [Budget €]) / 1000000)

Re: Variable in Setanalysis.

Anil_Babu_Samineni — Tue, 13 Sep 2016 09:02:17 GMT

Perhaps This, you made one mistake

Your variable is seems var_seriemax instead of v_seriemax

Can you please elaborate more what are you tried for variable of var_seriemax

= Sum ({$ <[number] = {'$(var_seriemax)'}, AnnoSerie = {'2016'}>} [Budget €] / 1000000)

= Sum ({$ <[number] = {'=$(var_seriemax)'}, AnnoSerie = {'2016'}>} [Budget €] / 1000000)

= Sum ({$ <[number] = {'$(=var_seriemax)'}, AnnoSerie = {'2016'}>} [Budget €] / 1000000)

Re: Variable in Setanalysis.

akshayjain90 — Tue, 13 Sep 2016 09:10:26 GMT

Use his -

= (Sum ({$ <[number] = {$(=$(v_seriemax))}, AnnoSerie = {'2016'}>} [Budget €]) / 1000000)

Re: Variable in Setanalysis.

ToniKautto — Tue, 13 Sep 2016 09:32:59 GMT

Please keep in mind that the dollar expansion is done prior to the chart being calculated, so the expression can not dynamically change for row to to row in the chart results.

Set expression and dollar expansion