topic Re: Num# or another function in QlikView

Num# or another function

Tue, 09 May 2017 17:12:11 GMT

Hi guys,

I have a field wich tells us the % of click share. My problem is that when it is less than 10% it shows "<10%". In other cases it shows "x%" (for example, "70%")

What I want to do, is to loose the percentaje symbol and in case it hase one the "<".

Can you tell me a way to do this? i heard about the Num# function but i really don't understand it. If you guys could help me with this, or another function I appreciate it.

Thanks!

Nico

Re: Num# or another function

Digvijay_Singh — Tue, 09 May 2017 17:27:30 GMT

Is it a numeric calculated field or directly read from source? can you share some sample values as well

Re: Num# or another function

sunny_talwar — Tue, 09 May 2017 17:27:37 GMT

May be this

Num#(KeepChar(FieldName, '0123456789')) as FieldName

Re: Num# or another function

Anonymous — Tue, 09 May 2017 17:27:56 GMT

try num#('###########.###%;<###########.###%')

--> this will set the numerical value, If you like you can set the formating with num, for example:

num(num#('###########.###%;<###########.###%'))

Re: Num# or another function

Tue, 09 May 2017 17:53:31 GMT

its read from the source. I get a field wich may content a percentaje number (like "70%", or "39,9%"), "<10%" or "--" in case it has no clicks

Re: Num# or another function

Tue, 09 May 2017 17:57:10 GMT

Robin thanks for the response!

what does all the ###### represent?

Could you explain me how the function works?

Nico

Re: Num# or another function

Anonymous — Tue, 09 May 2017 18:06:17 GMT

It's a number consisting of maximal 14 digits, the negative sign is "<" and everything is in percent...

Do you know the basics? , the difference between num#() and num()?

Re: Num# or another function

Tue, 09 May 2017 18:27:45 GMT

Great Sunny!! I used this and worked!!

Thanks a lot.

Nico

Re: Num# or another function

sunny_talwar — Tue, 09 May 2017 18:30:49 GMT

If you have decimal percentages, then I would modify this a little (added a decimal after 9 in the script below)

Num#(KeepChar(FieldName, '0123456789.')) as FieldName

Re: Num# or another function

Tue, 09 May 2017 18:34:45 GMT

Yes! I saw that, and did it!!

Thanks for your magic

Re: Num# or another function

Tue, 09 May 2017 18:39:52 GMT

Thanks i got it!!

Nico