Partial value and percentage in bar chart

[Amit_B]

Hi,

How can I see in a Bar chart both the value and the percentage as is possible in a Mekko chart?

According to the example, I need that in 2024 '400 (100%)' will appear, and in 2023 the values ​​with 70%-20%-10% will appear respectively.

When I change to percentages then all the columns are in the same  lenght (like Mekko chart) and I don't want that.

(Qlik Cloud)

Thanks.

[Anil_Babu_Samineni]

@Amit_B  In general , With Dual() such workaround is possible. 

Dual('Your expression for 400' & ' (' & 'Your expression for 100' & ')', 'Your expression for 400')

[Amit_B]

It did not work.

I wrote like this:

Dual(Sum(Amount) & ' (' & (Sum(Amount)/Sum(total<Year>Amount)) & ')', Sum(amount))

I also tried with the ' sign.