Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: How to show another dimension in a chart?

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.

sushil353
Honored Contributor II

Re: How to show another dimension in a chart?

Hi,

PFA

In the presentation tab you can hide the column.

HTH

Sushil