Stack barchart

[Anonymous]

Hi Qlik Experts,

I have to create a stack bar chart , where all 4 stacks should  cover 100% display but do not show value as % in data points.

They should show actual numbers for particular selection as shown in example below.

For eg- if for Jan, LMN has "Actual 1"=123 , "Actual 2"=22,"Actual 3"=11, then it should show as image 2.

I tried creating it by using normal stackbar chart & showing datapoint as number or % but its not solving the purpose.

Because when I try showing actuals as data points , the stack doesn't cover 100% display.

Image created in excel.

Appreciate the help,

Thanks in adv.

[Anonymous]

Hello,

have created a sample doc with data and stack chart.

And gets output as below-

While converting this same to 100% stack bar chart and using the approach suggested by you gives me garbage values on data segments.

Can you please suggest here.

[Sergey_Shuklin]

Hello!

You may find this thread useful too:

which Qlikview chart Use??

[Anonymous]

I have posted sample app with data in this thread. Can you please take a look.

[PrashantSangle]

Hi,

Please find attachment might help you

Regards,

Prashant

[woshua5550 · Accepted solution]

you can do it in two ways

1.one dimension and four expressions

2.two dimensions and one expressions

PFA

plz make sure that these two checkboxes are checked

@

[Anonymous]

This solution works totally !  Thank You.

[Anonymous]

This solution works totally !  Thank You.