Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Stack barchart

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.

16 Replies
Anonymous
Not applicable
Author

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
Specialist
Specialist

Hello!

You may find this thread useful too:

which Qlikview chart Use??

Anonymous
Not applicable
Author

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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
woshua5550
Creator III
Creator III

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

1.png

2.png@

Anonymous
Not applicable
Author

This solution works totally !  Thank You.

Anonymous
Not applicable
Author

This solution works totally !  Thank You.