Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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

View solution in original post

3 Replies
Not applicable
Author

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

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
Champion III
Champion III

Hi Yo can write your expression as

exp1+exp2+exp3


You cannot use it from another chart


Regards

ASHFAQ