topic Re: Need Help with chart in QlikView

Need Help with chart

Fri, 20 Nov 2020 18:02:30 GMT

Hi Experts,

I want to make a bar chart like example below, using 2 expressions where one will give me an overall count and the other one a specific count which will be always lower than the overall count. Please help me in how i can solve it

Thanks in Advance,

Cristian.

Re: Need Help with chart

maxgro — Mon, 03 Aug 2015 19:08:44 GMT

make a bar chart with 2 expressions (no dimensions) and

in style tab choose stacked

Re: Need Help with chart

Mon, 03 Aug 2015 19:17:34 GMT

Thanks for your help, but that will give me the sum of those 2 expressions and what I want is one into another like in the example.

Re: Need Help with chart

Anonymous — Mon, 03 Aug 2015 19:24:00 GMT

you just Need to define under tab peresentation

click on

Plot values inside Segment

Re: Need Help with chart

maxgro — Mon, 03 Aug 2015 19:39:38 GMT

I thinks he wants

2700 as sum of the 2 bar

2300 as lower bar

not

5000 as sum

2300 as lower

something like

sum(value2) 2300 yellow

sum(value) - sum(value2) 2700 - 2300 = 400 green

the problem is the value on data point for green bar

Re: Need Help with chart

Anonymous — Mon, 03 Aug 2015 20:07:38 GMT

that's possible too, just ise the dual function

first Expression = sum(Val)

second Expression = dual(sum(ValComplet),sum(ValComplet-Val))

Re: Need Help with chart

qlikviewwizard — Tue, 04 Aug 2015 05:50:06 GMT

Hi Canzovino

Can you provide some sample data and attach the file to demonstrate your requirement?

Re: Need Help with chart

jagan — Tue, 04 Aug 2015 09:59:48 GMT

Hi,

Try like this

For specific Count:

Count(DimensionName)

Overall Count:

=Count(TOTAL DimensionName) - Count(DimensionName)

Now select Stacked in Chart Properties -> Sytle -> Select Stacked

Hope this helps you.

Regards,

Jagan.