Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

Best practice for number format on divide by 1000

Hi All

I am about to place all my expression in master key , and i am not sure what is the right way if i have expression :-

sum(sales)

Should i input as :-

sum(sales)/1000

Pro :-

1. make the number not so many digit.

Con :-

1 user may not know the amount is divide by 1000

Any advise ? As i try to let user pick the expression and just click on number format = money.. and don't need to select custom and change the number by remove the last 2 digit and insert K . which is trouble some.

Paul

2 Replies
vikasmahajan
Honored Contributor III

Re: Best practice for number format on divide by 1000

So Don't  use sum(sales)/1000 in load script, you can use sum(sales)/1000 in expression of chart so that you can have both values full as well as user can see 1000 divided value.

Hope you understand.

Vikas

paulyeo11
Valued Contributor II

Re: Best practice for number format on divide by 1000

Hi Sir

I am not refer to load script , I refer to put my expression in QS AS MASTER KEY.

Any way thank you for your feedback.

Sent from my iPhone