topic Show Expression Label inside stacked bar chart in QlikView

Show Expression Label inside stacked bar chart

cbaqir — Tue, 10 Dec 2019 01:26:01 GMT

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

Re: Show Expression Label inside stacked bar chart

Brett_Bleess — Tue, 17 Dec 2019 19:18:38 GMT

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

https://community.qlik.com/t5/QlikView-Layout-Visualizations/Bar-Chart-Expression-label-inside-the-bar/m-p/395132#M18920

Regards,
Brett

Re: Show Expression Label inside stacked bar chart

cbaqir — Tue, 17 Dec 2019 19:22:30 GMT

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

Re: Show Expression Label inside stacked bar chart

Brett_Bleess — Tue, 17 Dec 2019 19:28:45 GMT

@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