9 Replies Latest reply: Jun 12, 2015 8:11 AM by Gnanasekaran K

# Qlikview Dynamic Stacked bar chart

Hi,

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

• ###### Re: Qlikview Dynamic Stacked bar chart

Can you expand on what you mean by dynamic dimensions?

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

• ###### Re: Qlikview Dynamic Stacked bar chart

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.

• ###### Re: Qlikview Dynamic Stacked bar chart

you can use Primary Add PrimaryPriority in dimension and

use below expression

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

Thanks

BKC

• ###### Re: Qlikview Dynamic Stacked bar chart

Try some thing like this

Dimensions: date and PrimaryPriority

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

In presentation tab enable the 'stacked' option

• ###### Re: Qlikview Dynamic Stacked bar chart

do you mean using a cyclic group ?

• ###### Re: Qlikview Dynamic Stacked bar chart

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,