Hi Amit ,
Thanks for your advice .
I tried this one already , but in my case the total amount may be in Billions , Millions & thousands also .
If I use Num function , I've to create multiple IF statements . so the RAM utilization will be more .
Is there any setting in QMC , so that it capture the same which we fix the number in chart to 2 in Qlikview Development.
I suspect your problem may be related to having different regional (formatting )options on your workstation and your server. Check the control panel | Region & Language | Additional Settings options on both machines.
Also make sure that the environment settings at the start of the QV script are the same - especially if you are using an include file to load them.
Failing these two, you may have some corruption in the model.
Hi Guys ,
Thanks for the advice's.
The Qlikview Sever which my company uses is QV11.20 SR8 .
So, in this SR8 the number format settings which we implemented on sheet objects doesn't capture when we publish it .
When i tried the same thing in QV 11.20 SR9 or above . it works .
So, it is a Qlikview server issue .
Thanks a lot for your help guys .