topic Re: Stacked and Grouped in a single bar chart? in QlikView

Stacked and Grouped in a single bar chart?

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

Can we present one expression as a single bar and two other expressions as stacked in a single chart?

Something like this.

Re: Stacked and Grouped in a single bar chart?

Anil_Babu_Samineni — Wed, 24 May 2017 12:08:58 GMT

Yes, We have the power of that? Can you share the data set please?

Re: Stacked and Grouped in a single bar chart?

prma7799 — Wed, 24 May 2017 12:13:38 GMT

Hi Balu,

Please share some sample data .

Thanks

Re: Stacked and Grouped in a single bar chart?

Wed, 24 May 2017 12:14:34 GMT

I have attached the excel sheet.

Blue is the sum of Red+Orange +Grey.

PS: I cannot open QlikView documents as I run the personal edition.

Thanks

Re: Stacked and Grouped in a single bar chart?

Wed, 24 May 2017 12:16:36 GMT

Hi,

I ve attached the datasheet in my previous reply.

Re: Stacked and Grouped in a single bar chart?

Wed, 24 May 2017 12:18:23 GMT

sorry I messed up: Blue= Red+Green+Yellow

Re: Stacked and Grouped in a single bar chart?

sunny_talwar — Wed, 24 May 2017 12:39:12 GMT

May be this

Re: Stacked and Grouped in a single bar chart?

Wed, 24 May 2017 12:42:31 GMT

Hey,

Exactly, but how ? Can you please brief here I cannot open Qlikview document as I am running the personal edition.

Re: Stacked and Grouped in a single bar chart?

prma7799 — Wed, 24 May 2017 12:48:08 GMT

As Sunny Bhai suggested...

PFA

In chart

Dimension

1.Dim

2.=Pick(Dim, Color, 'Blue')

Expression

=Sum(Value)

Re: Stacked and Grouped in a single bar chart?

Wed, 24 May 2017 13:43:26 GMT

Hey ,

Still, it isn't stacked.

Re: Stacked and Grouped in a single bar chart?

sunny_talwar — Wed, 24 May 2017 13:44:09 GMT

Script

Table:

CrossTable(Color, Value)

LOAD * INLINE [

Name_State, Red, Green, Yellow

Region 1, 1999, 4068, 1933

Region 2, 14148, 11063, 0

Region 3, 574, 4335, 3091

Region 4, 14506, 2368, 1126

Region 5, 11809, 22999, 12192

Region 6, 571, 4586, 3843

Region 7, 11430, 4922, 20648

Region 8, 9418, 25718, 0

Region 9, 2092, 6038, 5870

Region 10, 6689, 22687, 71624

Region 11, 12590, 41490, 6920

Region 12, 9336, 48555, 51109

Region 13, 19740, 17647, 3613

];

Dim:

LOAD * Inline [

Dim

];

Dimension

Dim

=Pick(Dim, Color, 'Blue')

Expression

=Sum(Value)

Background Color expression

=If(Dim = 1, If(Color = 'Yellow', Yellow(), If(Color = 'Red', LightRed(), If(Color = 'Green', LightGreen(), LightBlue()))), LightBlue())

Re: Stacked and Grouped in a single bar chart?

Wed, 24 May 2017 14:50:42 GMT

Thank you all for your timely help. You guys are great.

See you soon with another question

Re: Stacked and Grouped in a single bar chart?

Wed, 24 May 2017 14:51:27 GMT

Hey,

Thanks much.