I believe you will need to use two expressions to show this and that will be more efficient approach also (when in Version 11, we have conditional expresisons).
because when you use one expression and two different formatting on the basis of conditions, Qlikview will try to decide one format for expression to show on
axis when rendering chart and it is different from the values shown on bars etc. for example just set your number format for a
that is the reason you are not able to switch formatting on axis.
For version 10, I have made a workaround which will help you to solve your issue.
Please find the attached file.
It is not a perfect answer to your query but hope it helps.
T1.qvw 157.0 K
Thanks Ashutosh, your solution seems to work.
However, it seems I found another way that suits my problem better.
I’m using variable (let’s call it vFormatGraph), which specifies the correct number format for each of my metrics:
if(Data_Type ='Percentage', '##.#%'))
Then I’m using this expression to calculate my actuals:
In the chart, under number format, I selected ‘Expression Default’. This solution works perfectly.