Qlikview Dynamic Stacked bar chart

[microland]

Hi,

I would like to create a stacked bar chart with dynamic groups.

Currently I have created 4 expressions. I would like to load dynamically. Please help.

[b_garside]

Can you expand on what you mean by dynamic dimensions?

It appears you have four in play, two showing in the chart.

[ramoncova06]

do you mean using a cyclic group ?

[microland]

What I mean dynamic is, right now i have created 4 expressions like sev1, sev2, sev3, sev4 like below,

=Count ( {$<[TicketTypeId]={'1'}, PrimaryPriority={'sev1'}>}TicketNumber)

=Count ( {$<[TicketTypeId]={'1'}, PrimaryPriority={'sev2'}>}TicketNumber)

=Count ( {$<[TicketTypeId]={'1'}, PrimaryPriority={'sev3'}>}TicketNumber)

=Count ( {$<[TicketTypeId]={'1'}, PrimaryPriority={'sev4'}>}TicketNumber)

So i am getting 4 groups in stacked bar chart. Now Incase if one more severity gets added i may have to come back to the expression and add another. I would like to load theses stacked groups dynamically.

[Anonymous · Accepted solution]

you can use Primary Add PrimaryPriority in dimension and

use below expression

Count ( {$<[TicketTypeId]={'1'}>}TicketNumber)

Thanks

BKC

[Anonymous]

find example

[PradeepReddy]

Try some thing like this

Dimensions: date and PrimaryPriority

Expression : Count ( {$<[TicketTypeId]={'1'}>}TicketNumber)

In presentation tab enable the 'stacked' option

[microland]

Thanks Pradeep and balkumar. That really works. Now I am trying to show a line in the same chart to show the total no of tickets. But if i add one more expression am getting the total for all severity.

am trying to achieve something like this,

Please help.

[PradeepReddy]

in a Bar chart/Line chart/Combo chart,  2 dimensions with 2 expressions is not possible

[microland]

Is there any other workaround to achieve my requirement?