Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

CVR
Contributor

Num formatting for a reference line in scatter chart

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

 

 

1 Solution

Accepted Solutions
Partner
Partner

Re: Num formatting for a reference line in scatter chart

Try this:

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

View solution in original post

2 Replies
Partner
Partner

Re: Num formatting for a reference line in scatter chart

Try this:

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

View solution in original post

Support
Support

Re: Num formatting for a reference line in scatter chart

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

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.