issue in loading data from excel

[abc_18]

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.

[effinty2112]

Hi Shika,

If

Num(MTTR,'0.00')

doesn't work try

Num(Num#(MTTR,'0,00'),'0.00')

Good luck

Andrew

[arvind_patil]

Hi Shikha,

Please try num Function.

Num(MTTR) as [New Value]

Thanks,

Arvind Patil

[abc_18]

not getting proper value.

using this formula it's give me value like

1.00

0.96.

[avinashelite]

check the decimal DecimalSep Variable value once ..if its , change it to .

[Anil_Babu_Samineni · Accepted solution]

Can you check and update like below in Qlik environment

SET DecimalSep='.';

[abc_18]

I tried using num function only, but its replacing decimal icon with comma  ','

[avinashelite]

Could you share the sample EXCEL