Qlikview , Dual (Chart) function , Multiple value on data point

Credit : https://community.qlikview.com/thread/166577

As a requirement , how to display value on data point in difference way.

Example you have bar chart contain sum of sale across month. Let's say you want Y axis to show the exactly of sale summary , But value on bar chart showing % of each month vs total.

Using DUAL : DUAL Function
DUAL(Text ,Number)

Example =
DUAL(
  NUM(SUM(Sales)/SUM( TOTAL Sales) ,'#,##0.00%'),
  SUM(Sales)
)


The another useful technic to formatting the axis
https://community.qlik.com/thread/97554
Summary : Create a dummy expression and then set invisibility and set the number format in number tab as you want. Incredible! Marvellous!