Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
prma7799
Master III
Master III

value in Lacks

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

1 Solution

Accepted Solutions
prma7799
Master III
Master III
Author

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

View solution in original post

6 Replies
PrashantSangle

Hi,

Multiply by 100 You will get value in lack

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Kushal_Chawda

Load  Value*100 as LacValue

In your case 131.3 Cr will become 13130 Lac

prma7799
Master III
Master III
Author

Hi,

1301124536.9 This is my exact value

When i multiply by 100 then

I will get 130112453690

Thanks

prma7799
Master III
Master III
Author

Hi Kush,

I want integer format.

Thanks

prma7799
Master III
Master III
Author

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

Kushal_Chawda

Then divide by 100000

So, round(Value/100000)