topic Re: Stacked bar chart : Calculated Bars in QlikView

Stacked bar chart : Calculated Bars

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Stacked bar chart : Calculated Bars

sunny_talwar — Mon, 22 Aug 2016 23:45:09 GMT

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

Re: Stacked bar chart : Calculated Bars

Tue, 23 Aug 2016 00:03:57 GMT

What is the most efficient way to share it?

Re: Stacked bar chart : Calculated Bars

Anil_Babu_Samineni — Tue, 23 Aug 2016 03:35:37 GMT

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

Re: Stacked bar chart : Calculated Bars

Tue, 23 Aug 2016 04:38:46 GMT

Hi Jason,

Please go through below.....

How to use custom colours in a stacked bar chart

Thanks

Re: Stacked bar chart : Calculated Bars

sunny_talwar — Tue, 23 Aug 2016 08:11:20 GMT

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

Uploading a Sample

Re: Stacked bar chart : Calculated Bars

Tue, 23 Aug 2016 21:56:04 GMT

Sample qvw + excel file.

Re: Stacked bar chart : Calculated Bars

Tue, 23 Aug 2016 21:56:55 GMT

I attached the qvw and excel to simplify.

Re: Stacked bar chart : Calculated Bars

sunny_talwar — Tue, 23 Aug 2016 22:23:09 GMT

Is this what you want?

Re: Stacked bar chart : Calculated Bars

Tue, 23 Aug 2016 23:22:22 GMT

Exactly that.

Re: Stacked bar chart : Calculated Bars

sunny_talwar — Wed, 24 Aug 2016 00:47:50 GMT

So it seems that the attachment did not go through the first time, trying it again now

Re: Stacked bar chart : Calculated Bars

Wed, 24 Aug 2016 04:08:56 GMT

The result is as expected but i would like to be clear on the concept. Please elaborate if possible.

You created the Dim table.
=Pick(Dim,IGS,'Total','SubTotal') . Created this new dimension.
Wrote the expression :
Pick(Dim,

Count(MYNPS)/count(Total<IGS> MYNPS),

Count({<IGS = {'INSTALACION', 'REPARACIONES MOVILES'}>}MYNPS)/count({<IGS = {'INSTALACION', 'REPARACIONES MOVILES'}>} TOTAL <IGS> MYNPS))

What puzzles me is how 'Count(MYNPS)/count(Total<IGS> MYNPS)' is used exactly the same twice in the expression yet produces this Total Bar. I don't get how is achieved.

Re: Stacked bar chart : Calculated Bars

sunny_talwar — Wed, 24 Aug 2016 09:53:33 GMT

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

Re: Stacked bar chart : Calculated Bars

Fri, 26 Aug 2016 10:39:41 GMT

Thanks Sunny it is very clear now.