Solved: Re: Number format - Qlik Community

ssriramin19 · ‎2012-11-02

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

sivarajs · ‎2012-11-02

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

Anonymous · ‎2012-11-02

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

ssriramin19 · ‎2012-11-02

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

Report Inappropriate Content · ‎2012-11-02

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 · ‎2012-11-02

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 · ‎2012-11-02

Hello,

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

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

Cheers!!

Jagan Nalla

ssriramin19 · ‎2012-11-02

I tried it but still the same problem persists

sivarajs · ‎2012-11-02

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