Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

beck110979
Valued Contributor III

Num# shows wrong value-format

Hi Folks,

I got a question:

i want to show the numbers as dimensions, like: 1000, 6000, 7000,

But my values do look like: 1000,00 and 6000,00, i've used the Num#()-function, but it does not work.

Does anybody have any idea?

Thanks a lot

Beck

4 Replies

Re: Num# shows wrong value-format

If the numbers are fieldvalues floor(Field) should work. If it's the result of a calculation it needs to be wrapped with an aggr() like: aggr(floor(YourExpression), Dim1, Dim2).

- Marcus

MVP
MVP

Re: Num# shows wrong value-format

Num#() is an interpretation function, not a formatting function. Num#() produces the same format as the input data. You need the Num() function (no #). This is the formatting function. You can combine the fucntions like this

=Num(Num#(mynumber, '<incoming data format>'), '<desired output format>')

eg

=Num(Num#(mynumber, '0,00'), '0')

or

=Num(Num#(mynumber, '0,00'))

beck110979
Valued Contributor III

Re: Num# shows wrong value-format

Hi Jonathan,

i tried to implement your way of solution, but it does not work

praveenkumar_ma
Contributor

Re: Num# shows wrong value-format

Hi Beck,

Actual Num# syntax :

Num#(text[, format[, dec_sep [, thou_sep ] ] ])


Num syntax:


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


this might be helpful beck.


Thanks

PM