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.
yes of course, set Dimension = Name and measure = Sum(Value).
But that would group values in Name field together (Red)? I also really need to distinct the ID.
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.
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?
Dimension = (ID & Name) and Measure = Sum(Value).
Retrieving data ...