Two dimension chart

[janvomgcz]

Hi everyone,

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

Is this somehow achievable?

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

[agigliotti]

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

[janvomgcz]

Thanks,

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

[theglenndavid]

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]

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]

Try using:

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

[sumanta12]