Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
cbaqir
Specialist II
Specialist II

Show Expression Label inside stacked bar chart

I have a stacked bar chart with several expressions. I would like to show the expression label inside the bar chart along with the value. I've tried using dual but it only works on the legend and not what's actually displayed in the bar chart. Please help.

I want the yellow portion of the bar chart to say CPOE: value and the red to say Mpage: value.

=dual('CPOE: ' & sum(aggr(num(if(PRIMARY_ASSIGNEE=CPOE_RESOURCE, sum(distinct SUB_BUILD_NP_ACT_CPOE),0)),DEFECT_ID,PRIMARY_ASSIGNEE)),sum(aggr(num(if(PRIMARY_ASSIGNEE=CPOE_RESOURCE, sum(distinct SUB_BUILD_NP_ACT_CPOE),0)),DEFECT_ID,PRIMARY_ASSIGNEE)))

2019-12-09_18-24-18.jpg

 

3 Replies
Brett_Bleess
Former Employee
Former Employee

Check out the following Community Post, believe it should help:

https://community.qlik.com/t5/QlikView-Layout-Visualizations/Bar-Chart-Expression-label-inside-the-b...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
cbaqir
Specialist II
Specialist II
Author

That is the approach I tried above and it changed the label in the legend but not within the bar.

Brett_Bleess
Former Employee
Former Employee

@Gysbert_Wassenaar Reaching out to the guy that put things on that track to see if he can have a look at it directly for you...  You may want to post a sample QVW if you can, that may help quite a bit on this one.

Cheers,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.