Change the Y Axis Number Formatting based on measures

[Purushothaman]

Hi,

I have created the following measure:

if (Getfieldselections(Sales_type)='Percent',num(sum(per_sales)/100,'#,##0%' ),Num(sum(sales),'#,##0')) 

I want that the format of the Y axis will change accordingly. (if the user select 'Percent' it will display with percent format else number)

Thank you!

[Purushothaman]

Thank you!

[Purushothaman · Accepted solution]

This is a product limitation of Qlik. The Two possible method is:

1) Alternative measure

24 Alternative Measure in Qlik Sense - YouTube

2) Or Hide and Show using container