Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner
Partner

formatting number

Hello

I got a pivot table that contains numbers like 8897453

is there a number format that displays this number as divided by 1000 and thus the result is 8,897
I don't want to divide the number by 1000 but displayed as if divided by 1000

kindly advise

I can walk on water when it freezes
3 Replies
sunny_talwar

May be using Dual function? But don't understand the point of displaying it in one way and underlying being different?

ali_hijazi
Partner
Partner
Author

the thing is that we have so many expressions in a dashboard that are related to amounts in currencies

in these expressions we are already formatting amounts as num($(variable),variable_format)

where variable format contains the desired format which is now #,##0.00

First end users wanted to remove decimal points so the change was easy we went to the variable_format and made it #,##0
now the users decided that these amounts should be displayed with K so we needed to divide the amounts by 1000

however this modification is huge so I was trying to find if there is a rapid approach to this modification

I can walk on water when it freezes
sunny_talwar

okay, but don't know if there a better way to do this.