topic Re: Pie chart and value from table in QlikView

Pie chart and value from table

Tue, 17 Jun 2014 09:41:28 GMT

Hello all,

Is there a way to use the values from table in pie chart?

Table:

column1 column2 column3 column4

exp1 exp2 exp3 exp1+exp2+exp3

I want to put the values of column4 in pie chart.

Is it posssible?

Re: Pie chart and value from table

Tue, 17 Jun 2014 09:44:31 GMT

Nemanja

a pie chart will display 1 expression according to dimension

More than 1 (or 2) expression won't be easily readable.

You have to store your total at the same level of other dimension

best regards

Chris

Re: Pie chart and value from table

Gysbert_Wassenaar — Tue, 17 Jun 2014 09:47:40 GMT

No, that's not possible. You'll have to reuse the expressions from the chart and create one expression from them for the pie chart. What you can do is put the original expressions in variables and use the variables in the table and the pie chart. That way you'll have to maintain them in only one place.

vVar1: sum(X)

vVar2: sum(Y)

vVar3: sum(Z)

exp1: $(vVar1)

exp2: $(vVar2)

exp3: $(vVar3)

exp4: $(vVar1) + $(vVar2) + $(vVar3)

Re: Pie chart and value from table

ashfaq_haseeb — Tue, 17 Jun 2014 09:48:36 GMT

Hi Yo can write your expression as

exp1+exp2+exp3

You cannot use it from another chart

Regards

ASHFAQ