topic Num formatting for a reference line in scatter chart in QlikView

Num formatting for a reference line in scatter chart

CVR — Sat, 16 Nov 2024 19:42:37 GMT

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

Re: Num formatting for a reference line in scatter chart

Arthur_Fong — Tue, 12 Nov 2019 03:51:42 GMT

Try this:

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

Re: Num formatting for a reference line in scatter chart

Brett_Bleess — Wed, 13 Nov 2019 16:54:01 GMT

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