Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

janvomgcz
New Contributor II

Two dimension chart

Hi everyone,

I am trying to create a bar chart from two dimension dataset but showing one dimension only.

Is this somehow achievable?

twodimensionchart.jpg

I am quite new to Qlik Sense, any help would be much appreciated.

6 Replies
agigliotti
Honored Contributor II

Re: Two dimension chart

yes of course, set Dimension = Name and measure = Sum(Value).

janvomgcz
New Contributor II

Re: Two dimension chart

Thanks,

But that would group values in Name field together (Red)? I also really need to distinct the ID.

theglenndavid
New Contributor III

Re: Two dimension chart

You can add a secondary dimension (ID) on the bar chart. Depending on how you want to view the data, you can leave it grouped or stack them on the primary dimension.

janvomgcz
New Contributor II

Re: Two dimension chart

I would like to view the data exactly as shown in the enclosed example chart.

Something like  Dimension=Name  and  Measure=Sum("Distinct ID" Value) so

it would somehow show "Red" twice in a chart with different values (12 and 7).

Is this even possible?

agigliotti
Honored Contributor II

Re: Two dimension chart

Try using:

Dimension = (ID & Name) and Measure = Sum(Value).

sumanta12
Contributor II

Re: Two dimension chart

PIC.png

Community Browser