Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

microland
New Contributor II

Qlikview Dynamic Stacked bar chart

Hi,

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

ede.png

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

Tags (2)
1 Solution

Accepted Solutions
balkumarchandel
Valued Contributor II

Re: Qlikview Dynamic Stacked bar chart

you can use Primary Add PrimaryPriority in dimension and

use below expression

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

Thanks

BKC

9 Replies
b_garside
Valued Contributor

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.

ramoncova06
Valued Contributor III

Re: Qlikview Dynamic Stacked bar chart

do you mean using a cyclic group ?

Highlighted
microland
New Contributor II

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.

balkumarchandel
Valued Contributor II

Re: Qlikview Dynamic Stacked bar chart

you can use Primary Add PrimaryPriority in dimension and

use below expression

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

Thanks

BKC

balkumarchandel
Valued Contributor II

Re: Qlikview Dynamic Stacked bar chart

find example

pradeepreddy
Valued Contributor II

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

microland
New Contributor II

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,

ss.png

Please help.

pradeepreddy
Valued Contributor II

Re: Qlikview Dynamic Stacked bar chart

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

microland
New Contributor II

Re: Qlikview Dynamic Stacked bar chart

Is there any other workaround to achieve my requirement?

Community Browser