topic Re: Number format in QlikView

Number format

upaliwije — Wed, 10 Oct 2018 08:08:28 GMT

Hi Friends

I have in pivot table following expression.

IF(VALUELIST('GROSS PREMIUM NEW','REFUNDS NEW','NET PREMIUM NEW','GROSS PREMIUM RENEWAL','REFUNDS RENEWAL','NET PREMIUM RENEWAL','NET PREMIUM TOTAL','PREMIUM LAST YEAR','GROWTH %','BUDGET C.Y.','ACH.%')='ACH.%'

,(sum({$<PERIODID = {$(=Max(PERIODID))},MO_NM={'MOTOR'},YEAR =,QUARTER =,MONTH =,PERIOD =,DAY=>}[PREMIUM])/sum({$<PERIODID = {$(=Max(PERIODID))},MO_NM={'MOTOR'},YEAR =,QUARTER =,MONTH =,PERIOD =,DAY=>}[DAILY_BUDGET]))*100

Currently the Ach % is shown as 55 and I want Ach % to be shown as 55.3%. Kindly advise me ho to modify my expression

Re: Number format

uacg0009 — Wed, 10 Oct 2018 09:58:02 GMT

Hi UPALI,

in your expression, you don't need to * 100, and you need to use a num() function, like :

num(sum(xxx)/sum(xxx),'##.#%')

Aiolos Zhao

Re: Number format

upaliwije — Wed, 10 Oct 2018 10:30:42 GMT

Thanks Zaho

Still it shows the same way. I am using a pivot table pls mot a text box

Re: Number format

upaliwije — Wed, 10 Oct 2018 12:33:15 GMT

Hi Zaho

You formats works when I enter it as a individual expression. But when I couple it with if(valuelist...... Command it does not show in required format. Pls help

Valuelist Individual

REFUND RATIO NEW

51.6%

Re: Number format

upaliwije — Wed, 10 Oct 2018 16:05:53 GMT

‌hi friends,

can can someone suggest me a solution please.

Re: Number format

Anil_Babu_Samineni — Thu, 11 Oct 2018 00:33:48 GMT

Try this way?

,Num((sum({$<PERIODID = {$(=Max(PERIODID))},MO_NM={'MOTOR'},YEAR =,QUARTER =,MONTH =,PERIOD =,DAY=>}[PREMIUM])/sum({$<PERIODID = {$(=Max(PERIODID))},MO_NM={'MOTOR'},YEAR =,QUARTER =,MONTH =,PERIOD =,DAY=>}[DAILY_BUDGET]),'#,##0.0'))*100

Re: Number format

uacg0009 — Thu, 11 Oct 2018 02:16:42 GMT

Hi UPALI,

I think it will be the same whether you use it in valuelist or not...

Like below Anil said, in your table's properties - Number tab, what's your format setting you selected, you can try to use the expression default.

Aiolos Zhao

Re: Number format

upaliwije — Thu, 11 Oct 2018 11:38:02 GMT

Thanks

When I apply your expression I get more than one decimal points

Pls help