Can I have 2 data labels on a stacked bar chart?

[Sttran]

I have a stacked bar chart that shows sales by product by month. The first data label will be % of sales by product, this is easy to do. Is there a way to add a second data label with the expression to calculate average price using the formula of sales/item?

[igoralcantara]

A Stack bar chart you can have either 2 dimensions OR 2 measures, not both. If you have one dimension, simply add a second measure. If you have 2 dimensions, change the ToolTip property, under the appearance area in the chart properties.

[Lech_Miszkiewicz]

Hi @Sttran 

Normally you could use Dual() and Format number by "Measure expression" to achieve this

for example:

Dual(
	num(Sum(Expression1)/1000,'#,##0')&' ['& num(Sum(Expression2)/Sum(Expression1)*100,'#,##0 %')&']', // Label
	Sum(Expression1)	// Actual measure
)

however currently it appears Qlik Sense has a bug (which I have reported with Qlik support) when you switch to "stacked" mode it does not retain formatting.

Therefore the only option you have at the moment is custom tooltip.