Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need Help with chart

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

barra.png

Thanks in Advance,

Cristian.

7 Replies
maxgro
MVP
MVP

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

in style tab choose stacked

Not applicable
Author

   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
Not applicable
Author

you just Need to define under tab peresentation

click on

Plot values inside Segment

maxgro
MVP
MVP

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

1.png

Anonymous
Not applicable
Author

that's possible too, just ise the dual function

first Expression = sum(Val)

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

qlikviewwizard
Master II
Master II

Hi Canzovino

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

jagan
MVP & Luminary
MVP & Luminary

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.