topic Call Variables in Set Analysis in QlikView

Call Variables in Set Analysis

Tue, 13 Sep 2011 16:36:45 GMT

Hi everyone,

Need i little help here:

A create a variable that i called variable_a.

Then im trying to make Sum({$<id={'variable_a'}>} Costs).

It doesn't work.

Any suggestions for that?

Thanks,

Eliano

Jason_Michaelides — Tue, 13 Sep 2011 17:14:14 GMT

I can never quite remember the syntax without looking at my own previous uses (which I can't do now!) but try:

Sum({$<id={'$(variable_a)'}>} Costs)

Sum({$<id={"$(variable_a)"}>} Costs)

If neither works I'll go and look it up!

Jason

Tue, 13 Sep 2011 17:58:39 GMT

Didn't work.

Anyother suggestions?

Thanks,

Eliano

Jason_Michaelides — Tue, 13 Sep 2011 18:08:51 GMT

I seem to remember an example being in the F1 help in Set Analysis. Have a look there.

Tue, 13 Sep 2011 18:10:07 GMT

I solve it out.

thanks