Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Pie chart and value from table

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?

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Not applicable

Re: Pie chart and value from table

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)


talk is cheap, supply exceeds demand
3 Replies
Not applicable

Re: Pie chart and value from table

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

Gysbert_Wassenaar
Not applicable

Re: Pie chart and value from table

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)


talk is cheap, supply exceeds demand
ashfaq_haseeb
Not applicable

Re: Pie chart and value from table

Hi Yo can write your expression as

exp1+exp2+exp3


You cannot use it from another chart


Regards

ASHFAQ