Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
beck_bakytbek
Honored Contributor

Num# of numbers

Hi Folks,

my filed does look like:

Class

120,00

 

i am trying to format (from 120,00 to 120) it by using of function num#() but i dont achieve any expected results.

Does anybody have any idea?

Thanks a lot

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Num# of numbers

For me it worked with:

num(num#('120,00', '###,##', ',', '.'), '#.##0')

floor(num#('120,00', '###,##', ',', '.'))

- Marcus

View solution in original post

6 Replies
Support
Support

Re: Num# of numbers

hello,

something like this,

Num(number[, format[, dec_sep [, thou_sep]]])

 

Regards,

Akshesh

Highlighted
beck_bakytbek
Honored Contributor

Re: Num# of numbers

Hi Akshesh,

 thanks a lot for your responce, i implemented that, but it does not work 

MVP & Luminary
MVP & Luminary

Re: Num# of numbers

Num#() is for converting a string into a number - it will return (if the recognition-pattern is set properly) the number with the default number-format (set per variable in the main-tab of the script). If you want to change the format you need to adjust this variable or to wrap the num#() with a num(). Important by adjusting the delimiter is that all parameter of num() are set.

Another way in your case might be just to use floor().

- Marcus

beck_bakytbek
Honored Contributor

Re: Num# of numbers

Hi Marcus,

thanks a lot for your responce, i tried to implement it by using of Floor-function, as Floor(120,00), but it does not work

MVP & Luminary
MVP & Luminary

Re: Num# of numbers

For me it worked with:

num(num#('120,00', '###,##', ',', '.'), '#.##0')

floor(num#('120,00', '###,##', ',', '.'))

- Marcus

View solution in original post

beck_bakytbek
Honored Contributor

Re: Num# of numbers

Hi Marcus,

thanks a lot for your time and help, it does work great