Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
klrameet
New Contributor II

Color the bar graph by 2 dimensions

Hi 

I am plotting this combo bar chart, where the 2 amount fields are getting plotted on Y-axis against the unique number of X.

The underline data is for multiple dates, so if users selects more than one date, the amount columns are displaying the sum of it, which is okay. but the problem is total is displayed in a single color whereas i want it to display different color for the total by date.

DateUnique IDAmount AAmount B
12/31/2018156831,200,00031,200,000
12/31/2018158415,000,00015,000,000
12/31/20182478315,000,00015,000,000
12/31/20181621714,400,00014,400,000
09/30/2018156820,800,00020,800,000
09/30/2018158410,000,00010,000,000
09/30/20182478310,000,00010,000,000
09/30/2018162179,600,0009,600,000

 


Capture.JPGAs you can see, the graph is displaying total for both the dates, across each unique ID whereas I am trying to get to split each bar into 2 colors, one for every unique date. Something like below 

Appreciate your inputs and help on this ..  

 

Capture.JPG

3 Replies
Channa
Valued Contributor III

Re: Color the bar graph by 2 dimensions

you looking for two stack for 1 dimension

try to have two separate charts 

Channa
Channa
Valued Contributor III

Re: Color the bar graph by 2 dimensions

another way is concatenate date and ID, it is better , user can see date as well 

Channa
klrameet
New Contributor II

Re: Color the bar graph by 2 dimensions

it's very important that two different measures for the given dimension to be plotted side by side.