topic Re: formatting numbers in QlikView

formatting numbers

master_student — Thu, 12 Oct 2017 08:30:09 GMT

Hello Guys,

I have an expression that return a value with exponentielle :

here is th expression :

=num(((sum({$<[Year of date]={$(=Max([Year of date]))},RVN_DATA_CHANNEL = >}RVN_AIRTIME) -sum({$<[Year of date]={$(=Max([Year of date]))},RVN_DATA_CHANNEL -= {'Shops'}>}MNT_DATA))

- (sum({$<[Year of date]={$(=Max([Year of date])-1)},RVN_DATA_CHANNEL = >}RVN_AIRTIME) -sum({$<[Year of date]={$(=Max([Year of date])-1)},RVN_DATA_CHANNEL -= {'Shops'}>}MNT_DATA)))

/sum({$<[Year of date]={$(=Max([Year of date])-1)},RVN_DATA_CHANNEL = >}RVN_AIRTIME) -sum({$<[Year of date]={$(=Max([Year of date])-1)},RVN_DATA_CHANNEL -= {'Shops'}>}MNT_DATA)*100,'# ## % ')

I need one number after the comma

How to correct it ?

Thanks

Re: formatting numbers

prma7799 — Thu, 12 Oct 2017 08:38:01 GMT

Try like

=num((Expression),'#,##0')

Re: formatting numbers

Anil_Babu_Samineni — Thu, 12 Oct 2017 08:38:29 GMT

Are you looking 1,5 %??

Re: formatting numbers

master_student — Thu, 12 Oct 2017 08:40:34 GMT

yes

Re: formatting numbers

Anil_Babu_Samineni — Thu, 12 Oct 2017 08:50:31 GMT

If possible please share workfile to test. OR Use #,0 %

Re: formatting numbers

pradosh_thakur — Thu, 12 Oct 2017 09:12:21 GMT

try this

expression:

=num((((sum({$<[Year of date]={$(=Max([Year of date]))},RVN_DATA_CHANNEL = >}RVN_AIRTIME) -sum({$<[Year of date]={$(=Max([Year of date]))},RVN_DATA_CHANNEL -= {'Shops'}>}MNT_DATA))

- (sum({$<[Year of date]={$(=Max([Year of date])-1)},RVN_DATA_CHANNEL = >}RVN_AIRTIME) -sum({$<[Year of date]={$(=Max([Year of date])-1)},RVN_DATA_CHANNEL -= {'Shops'}>}MNT_DATA)))

/(sum({$<[Year of date]={$(=Max([Year of date])-1)},RVN_DATA_CHANNEL = >}RVN_AIRTIME) -sum({$<[Year of date]={$(=Max([Year of date])-1)},RVN_DATA_CHANNEL -=

{'Shops'}>}MNT_DATA)))*100,'#,## 0')

& '%'

regards

Pradosh