Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

In QS the measure expression format how to make it default as number instead of auto ?

HI All

each time I create a measure , I alway need to change Auto to number .

As if it is auto , the number display will with out comma and it is not align and hard for user to read , so I need to change to number, only when i Compute in GP % , other then that most of the time is number.

any way to default to number ?

paul

7 Replies
paulyeo11
Master
Master
Author

Hi Vas

I aware of the formatting function , the developer should know the 90% of the measure are number and it should set number as default.

May be this is another bug.

Paul Yeo

DIrector

TDS Technology (S) umber P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

Vasiliy_Beshentsev
Creator III
Creator III

And exactly that the point you try to achieve. If you want to auto default to number your measure, you can write format which you want to see in expression.

Some time ago i got this point and just write my own format as i want.

2017-06-09 15_58_55-Qlik Sense Desktop.png

paulyeo11
Master
Master
Author

Yes I aware can make use script but then I am scare to write those as it is a lot of " ' , very confuse to learn.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

Vasiliy_Beshentsev
Creator III
Creator III

Don't scare i'm with you.

paulyeo11
Master
Master
Author

This is correct answer finally , pls don't blame me as you will be very busy.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

Vasiliy_Beshentsev
Creator III
Creator III

it' ok, always like to help