Show Percentage on Stacked Bar Graph

[Ipsita20191]

Data as per below:

I want to show the percentage on stacked bar graph but not in 100% stacked bar graph.

I have used dual function, still I am not able to create percentage on stacked bar . Everytime it is creating 100% stacked bar graph which I don't want.

Used this logic : =Dual(Num(Sum(fBooked), '#,###.') & Chr(10) & Num(Sum(fBooked)/Sum(TOTAL <Brand> fBooked), '##.##%'), Sum(fBooked)) -------------  But not working

Booked	Brand	sum(fBooked)	sum(total <Brand> fBooked)	sum(fBooked)/ (sum(total <Brand> fBooked))
Late	A	147	267	55.1%
On Time	A	118	267	44.2%
No Data	A	2	267	0.7%
On Time	B	21	52	40.4%
Late	B	16	52	30.8%
No Data	B	15	52	28.8%

[ajaykakkar93]

Hi,

If you're using Qlik Sense version 2023, you can benefit from the "Add Measure in Tooltip" option for this use case.

[Ipsita20191]

Tooltip is something when we want to show more measures details in a graph.

May be my table gave you wrong impression. I have two dimension and one measure .other two columns just showing how I am getting % column.

PO Booked	Brand	sum(fBooked)/ (sum(total <Brand> fBooked))
Late	A	55.1%
On Time	A	44.2%
No Data	A	0.7%
On Time	B	40.4%
Late	B	30.8%
No Data	B	28.8%

And I want stacked graph. But not 100 % stacked graph.

[ajaykakkar93]

Brand A has a total of 100%, so it will remain the same.

alternatively try below option

[Ipsita20191]

Thanks for the reply. I tried the same, but it is showing as 100% stacked.However I don't want 100% stack graph.

Because, when I tried in Qlikview it is showing normal stacked graph not 100% .

[ajaykakkar93]

Can you share a sample of qlik view

[Ipsita20191]

Attached here with Qlik View. I am able to create the graph with same formula.