topic value in Lacks in QlikView

value in Lacks

prma7799 — Wed, 15 Jul 2015 07:37:06 GMT

Hi All,

Can anybody fulfill this small requirement.

i have create one text object in that values come in crores i want that in Lacs

eg. 131.3 ----- this is in crores

I want above value in lacks with integer format.

Thanks

PrashantSangle — Wed, 15 Jul 2015 07:41:12 GMT

Hi,

Multiply by 100 You will get value in lack

Regards

Kushal_Chawda — Wed, 15 Jul 2015 07:43:25 GMT

Load Value*100 as LacValue

In your case 131.3 Cr will become 13130 Lac

prma7799 — Wed, 15 Jul 2015 07:46:27 GMT

Hi,

1301124536.9 This is my exact value

When i multiply by 100 then

I will get 130112453690

Thanks

prma7799 — Wed, 15 Jul 2015 07:47:29 GMT

Hi Kush,

I want integer format.

Thanks

prma7799 — Wed, 15 Jul 2015 07:53:48 GMT

Thanks I got Answer I divide by 100000 and use Num function.

Kushal_Chawda — Wed, 15 Jul 2015 07:55:18 GMT

Then divide by 100000

So, round(Value/100000)