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: 
qlikviewaf
Creator
Creator

Number Format

Hi Guys,

this is what i have in my app.

I would like to have just thousand ,  for example 9.532, i would like to see only 10 (rounded)

for 45.735 i would like to see 46

for 19.106 i would like to see 19

I tried to change the format pattern, but i didnt get the result expected.

Any advice how to setup the format pattern?

Thank you!

NUMBER FORMAT.png

16 Replies
qlikviewaf
Creator
Creator
Author

Cattura.PNG

avinashelite

After applying Round() >Go to chart Properties >number > set the expression to default format that will give the result

qlikviewaf
Creator
Creator
Author

not working,  i would like to see only 159 not 159580 (example based on the first row)

Cattura.PNG

vinieme12
Champion III
Champion III

Just divide by 1000 then !

=if(vExcludeInstrumentSales,

Sum({<Area-={'Area-not-available'},Year=, Month=, Quarter=, Week=, Day=,Invoice_Date=,  Invoice_Date_Num={">=$(=Num(MonthStart(Max(Invoice_Date_Num))))<=$(=Max(Invoice_Date_Num))"}>} ExtendedUSD),

Sum({<Area-={'Area-not-available'},Year=, Month=, Quarter=, Week=, Day=,Invoice_Date=, Item_Category={$(vNoInstruments)}, Invoice_Date_Num={">=$(=Num(MonthStart(Max(Invoice_Date_Num))))<=$(=Max(Invoice_Date_Num))"}>} ExtendedUSD))

/1000

159.580  = 160 i hope that is what you were after since the beginning!

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
marcus_malinow
Partner - Specialist III
Partner - Specialist III

My bad :

£ #,##0;-£ #,##0

balabhaskarqlik

Rounding Data.png

Anonymous
Not applicable

Hello - you can use the box called Thousand Symbol; in your example you would add K instead of "Thous".  Qlik will adjust how the number displays without you having to divide by 1000. 

Thousand.PNG

Hope this helps,

Kathleen