Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
beck_bakytbek
Master
Master

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
marcus_sommer

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

jonathandienst
Partner - Champion III
Partner - Champion III

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'))

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
beck_bakytbek
Master
Master
Author

Hi Jonathan,

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

praveenkumar_ma
Partner - Creator
Partner - Creator

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