Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In my excel sheet data is in below format
MTTR |
100.00 |
96.98 |
when I load this data in qlikview,
qlikview showing data as
100,00
96,00
means replacing decimal value with comma ie' :- ','
how can I do it, I tried using num function but no luck.
Can you check and update like below in Qlik environment
SET DecimalSep='.';
Hi Shika,
If
Num(MTTR,'0.00')
doesn't work try
Num(Num#(MTTR,'0,00'),'0.00')
Good luck
Andrew
Hi Shikha,
Please try num Function.
Num(MTTR) as [New Value]
Thanks,
Arvind Patil
not getting proper value.
using this formula it's give me value like
1.00
0.96.
check the decimal DecimalSep Variable value once ..if its , change it to .
Can you check and update like below in Qlik environment
SET DecimalSep='.';
I tried using num function only, but its replacing decimal icon with comma ','
Could you share the sample EXCEL