topic Qlikview Dynamic Stacked bar chart in QlikView

Qlikview Dynamic Stacked bar chart

microland — Thu, 11 Jun 2015 11:10:54 GMT

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.

Re: Qlikview Dynamic Stacked bar chart

b_garside — Thu, 11 Jun 2015 15:22:44 GMT

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

ramoncova06 — Thu, 11 Jun 2015 15:53:58 GMT

do you mean using a cyclic group ?

Re: Qlikview Dynamic Stacked bar chart

microland — Fri, 12 Jun 2015 06:22:54 GMT

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

Anonymous — Fri, 12 Jun 2015 06:38:34 GMT

you can use Primary Add PrimaryPriority in dimension and

use below expression

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

Thanks

BKC

Re: Qlikview Dynamic Stacked bar chart

Anonymous — Fri, 12 Jun 2015 06:50:59 GMT

find example

Re: Qlikview Dynamic Stacked bar chart

PradeepReddy — Fri, 12 Jun 2015 07:23:26 GMT

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

microland — Fri, 12 Jun 2015 08:13:52 GMT

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.

Re: Qlikview Dynamic Stacked bar chart

PradeepReddy — Fri, 12 Jun 2015 09:50:13 GMT

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

Re: Qlikview Dynamic Stacked bar chart

microland — Fri, 12 Jun 2015 12:11:12 GMT

Is there any other workaround to achieve my requirement?