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

How to show another dimension in a chart?

Hi all, I have a table data like this:

IDDescriptionAmount
11111AAA30
22222AAA40
33333BBB20
44444CCC10

55555

CCC50
55555CCC60
22222AAA10

I need to sum the field "Amount" by "ID", but in my chart I'd like to show the corrispondent value of the field "Description".

I need an output like this:

DescriptionAMOUNT
AAA30
AAA50
BBB20
CCC10
CCC110

How can I obtain this output?

2 Replies
Gysbert_Wassenaar

Create a straight table with ID and Description as dimensions and sum(Amount) as expression. Then on the presentation tab choose the ID column and choose the option Hide Column.


talk is cheap, supply exceeds demand
sushil353
Master II
Master II

Hi,

PFA

In the presentation tab you can hide the column.

HTH

Sushil