Num formatting for a reference line in scatter chart

[CVR]

Hello QlikGeeks,

I am having trouble in getting the output in desired number format (%). I have tried "Num "function but it was not working. I want use this expression as a reference line in scatter chart for X-axis for which the labels are in %.

=If(WildMatch(Concat(Distinct Wireless, ','), 'A*', 'T*'), 86, 76)

"Wireless" is the field 

Desired output = 86% or 76%.

Thanks in Advance,

CVR

[Arthur_Fong · Accepted solution]

Try this:

=NUM(If(WildMatch(Concat(Distinct Wireless, ','), 'C*', 'W*'), 86, 76)/100,'00%')

[Brett_Bleess]

Veera, did Arthur's post do the trick for you?  If so, do not forget to return back to the thread and use the Accept as Solution button on his post to give him credit for the help and to let others know his suggestion worked.  If you are still working upon things, leave an update.

Regards,
Brett