topic Help for using set analysis in gauge chart in QlikView

Help for using set analysis in gauge chart

Mon, 22 Apr 2013 15:25:07 GMT

Hi all, I am tryng to produce several gauge chart, wher each one has to show an average of values in a same field, selected using other 2 fields (OP-CO and Area):

I would like to use a variable to select the value of the first field (OP-CO), but if I use the variable name, the chart disappear (ex. 1), while if I put the exact value (ex. 2), it is correct:

Ex 1: avg({$<[OP-CO] = {'$([OP-CO_1])'}, Area={'Quality'}>} [Assessment Value])

Ex 2: avg({$<[OP-CO] = {'Denmark'}, Area={'Quality'}>} [Assessment Value])

Do I miss something?

Thanks a lot for helping!

Matteo

Re: Help for using set analysis in gauge chart

Mon, 22 Apr 2013 15:45:07 GMT

SO number 2 works?

Im guessing that [OP_CO_1] is a field within OP-CO?

What do lock it as variable?

why not just do like in DENMARK?

Re: Help for using set analysis in gauge chart

kaushiknsolanki — Mon, 22 Apr 2013 16:50:41 GMT

Hi,

Try this way.

Create a variable vVariable1 = Denmark and then use the below expression.

avg({$<[OP-CO] = {'$(vVariable1)'}, Area={'Quality'}>} [Assessment Value])

Regards,

Kaushik Solanki