Solved: Re: Stacked bar chart : Calculated Bars - Qlik Community

Report Inappropriate Content · ‎2016-08-22

Greetings,

I have the following Stacked bar chart. (See picture). But i need to produce additional bars that are calculated based on others.

My Expression : Count(CRITICALITY)/count(Total<PRODUCT> CRITICALITY).

For example :

1 - If i want to create the total from A-F , within this same graph. It will be a 7th column.

2 - Create a Subtotal column just for E - F. within this same graph.

3 - Or a combination of both.

sunny_talwar · ‎2016-08-24

1) Yes, Dim table is a Island table which isn't connected to the data model and we can use it to drive as many additional columns as we want in your chart. Since we needed 2 extra, I added 1, 2, 3. 1 for the actual dimension and 2 more for the additional columns needed.

2) That is just the way to add additional dimensions in your chart

3) Think of these are two separate charts. One chart is with 2 dimensions and the other one is with only one dimension. So basically for TOTAL and SUBTOTAL bars, the only dimension is the second dimension whereas for IGS has two dimensions?

Does it make sense? If not, I am more than happy to try again

Best,

Sunny

View solution in original post

sunny_talwar · ‎2016-08-22

Would you be able to share the data behind this to help you with your requirment

Report Inappropriate Content · ‎2016-08-22

What is the most efficient way to share it?

Anil_Babu_Samineni · ‎2016-08-22

Where do you using the sorting to get the A-F data

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Report Inappropriate Content · ‎2016-08-23

Hi Jason,

Please go through below.....

How to use custom colours in a stacked bar chart

Thanks

sunny_talwar · ‎2016-08-23

Share it in an Excel file or share your sample qvw.

Uploading a Sample

Report Inappropriate Content · ‎2016-08-23

Sample qvw + excel file.

Report Inappropriate Content · ‎2016-08-23

I attached the qvw and excel to simplify.

sunny_talwar · ‎2016-08-23

Is this what you want?

Report Inappropriate Content · ‎2016-08-23

Exactly that.