Dynamically Convert Number to percentage in qlik sense

[#1]

is there a way of dynamically changing a format of a bar chart depending on its values....

some rows of data are for percentages

KPI=

1)Attaintment in  75%

2)Sales in  1008   number value

when user select Attainment bar should be in % when user selects sales it should be number

i tried using the option

=NUM( (sum(sales)/Sum(target))*100, '##.##%','.',',')

also tried

=NUM( (sum(sales)/Sum(target)), '##,00%',',','.')

or

= values &'%'

same expression in working in text box but not working in line chart. i have set the formatting to 'AUTO'.

Please suggest an option to fix the issue

[MK9885]

You can check this link

Dynamic formatting of a bar chart