Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
RutiTaumanRubin
Creator
Creator

Change number formatting in Y-axis - Qliksense

Hi,

I have created the following measure:

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

If the user select the option 'Percent' - the measure display as percent else as number..

Also 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)


Is this possible?

2018-01-29_12-32-13.png

Thank you!

0 Replies