topic Re: Combined Stacked and Grouped Bar Chart in QlikView

Combined Stacked and Grouped Bar Chart

timbatman — Sat, 16 Nov 2024 02:54:08 GMT

I have four variables of interest:

Q1CompCost, Q1WaterCost, Q2CompCost, Q2WaterCost

I wanted a stacked bar chart by quarter, but I can seem to only get all 4 variables to stack or all 4 to be side by side. Any ideas?

Claudiu_Anghelescu — Fri, 26 Jul 2019 12:31:59 GMT

Dimension1:

=valuelist('Q1CompCost', 'Q1WaterCost')

Dimension2:

=valuelist('Q2CompCost', 'Q2WaterCost')

Expression Q1:

=if(valuelist('Q1CompCost', 'Q1WaterCost') ='Q1CompCost',
sum(expr))

Expression Q1:

=if(valuelist('Q1CompCost', 'Q1WaterCost') ='Q1WaterCost',
sum(expr))

Expression Q2:

=if(valuelist('Q2CompCost', 'Q2WaterCost') ='Q2CompCost',
sum(expr))

Expression Q2:

=if(valuelist('Q2CompCost', 'Q2WaterCost') ='Q2WaterCost',
sum(expr))

Put the same name for both expressions in each Quarter: Q1 and Q2 for example

Claudiu_Anghelescu — Fri, 26 Jul 2019 12:37:29 GMT

if not works you can try also this:

Dimension:

=valuelist('Q1', 'Q2')

Expression Q1:

=if(valuelist('Q1', 'Q2') ='Q1',
sum(Q1CompCost))

Expression Q1:

=if(valuelist('Q1', 'Q2') ='Q1',
sum(Q1WaterCost))

Expression Q2:

=if(valuelist('Q1', 'Q2') ='Q2',
sum(Q2CompCost))

Expression Q2:

=if(valuelist('Q1', 'Q2') ='Q12,
sum(Q2WaterCost))

...and use the same color for each measure.

timbatman — Fri, 26 Jul 2019 14:27:09 GMT

Thank you, worked perfectly.