topic Re: Number format in QlikView

Number format

ssriramin19 — Fri, 02 Nov 2012 09:42:44 GMT

Hello

My requirement is that I have certain fields as the range 0.00734836 , and 0.00865531.But I want that to convert to 734836 , 865531.

Can anyone please suggest me how to resolve the above issue.

Thanks

Anonymous — Fri, 02 Nov 2012 09:46:11 GMT

Can't you simply multiply it by 100,000,000?

ssriramin19 — Fri, 02 Nov 2012 10:00:36 GMT

I am using the expression

(Sum(distinct([Supply Plan])))

& num(if(Plan_For_Month >=monthstart(today()),Sum(distinct([Supply Plan 1]))))

and dimension is two month field.

The highlighted dark numbers needs to be changed from 0.0073486 to 73486.

But if I multiply it to 100,000,000 then all the values gets changes .But that should not happen

Please advise some solution to the above problem

Fri, 02 Nov 2012 10:06:52 GMT

cud u pls post ur expression, is the expression which u've posted i sthe actua; expression ?

can't u simply check,using if, the sum returned is less than zero,then multiply by that figure ?

ssriramin19 — Fri, 02 Nov 2012 10:11:01 GMT

It is only for certain months the values needs to be modified and it can't be multiplied because on the whole it gets multiplied for the whole table

I tried but it not works

jagannalla — Fri, 02 Nov 2012 10:14:05 GMT

Hello,

Hope it helps you.,..according to your first post.

Num(Trim(Replace(Field1,Left(Field1,2),''))) as Field1

Cheers!!

Jagan Nalla

ssriramin19 — Fri, 02 Nov 2012 10:23:21 GMT

I tried it but still the same problem persists

sivarajs — Fri, 02 Nov 2012 11:54:47 GMT

Try this num(Replace(YourExpression,'.','0'),'###0')