topic Re: Different Colors in Grouped Bar chart in QlikView

Different Colors in Grouped Bar chart

ashok1203 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I need to create a bar chart based on below attached data. Need to create a bars based on Field data. Again I need variant different colours based on Field1.

The output needs like below Capture image with two colours for total tickets as it's combination of two fields data(

Back log

Received)

and with two colours for Open tickets as it's combination of two fields data(

Pending with user/Vendor

Inprogress)

Re: Different Colors in Grouped Bar chart

vishsaggi — Wed, 24 May 2017 20:31:19 GMT

Something like this?

You have to transform your data using Enable Transformation Step from TableFiles. It is not straight forward. Let me know if this is what you are looking?

Re: Different Colors in Grouped Bar chart

ashok1203 — Thu, 25 May 2017 01:59:08 GMT

Yes, But in the Tickets total i need to represent two colours like stacked bar that represent the Backlog and Received Information and for other one more bar also same represent two colours in the same bar that will represent the Inprogress and Pending with User/vendor data.

Re: Different Colors in Grouped Bar chart

vishsaggi — Thu, 25 May 2017 02:46:28 GMT

You excel sheet data is not consistent, can you give me some comprehensive data sample with good field names.

Re: Different Colors in Grouped Bar chart

ashok1203 — Thu, 25 May 2017 03:03:14 GMT

That is my original data bro...

Attached image is the required output and need to add colours to the bars based on the field1 data.

Re: Different Colors in Grouped Bar chart

vishsaggi — Thu, 25 May 2017 11:59:29 GMT

You are basically asking a Grouped chart combined with stacked bar chart for few expressions? Are you ? If yes, it is not possible to have Grouped and Stacked in the same chart. You have to use layover charts for that. Like two bar charts with one transparent.

Read here:

Combination of grouped and stacked bar chart (s... | Qlik Community