Need Help with chart

[#1]

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.

[maxgro]

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

in style tab choose stacked

[#3]

   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.

[Anonymous]

you just Need to define under tab peresentation

click on

Plot values inside Segment

[maxgro]

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

[Anonymous]

that's possible too, just ise the dual function

first Expression = sum(Val)

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

[qlikviewwizard]

Hi Canzovino

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

[jagan]

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.