topic Re: issue in loading data from excel in QlikView

issue in loading data from excel

abc_18 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 24 Jul 2017 09:17:17 GMT

Hi Shika,

Num(MTTR,'0.00')

doesn't work try

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

Good luck

Andrew

arvind_patil — Mon, 24 Jul 2017 09:19:45 GMT

Hi Shikha,

Please try num Function.

Num(MTTR) as [New Value]

Thanks,

Arvind Patil

abc_18 — Mon, 24 Jul 2017 09:20:26 GMT

not getting proper value.

using this formula it's give me value like

1.00

0.96.

avinashelite — Mon, 24 Jul 2017 09:21:05 GMT

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

Anil_Babu_Samineni — Mon, 24 Jul 2017 09:21:34 GMT

Can you check and update like below in Qlik environment

SET DecimalSep='.';

abc_18 — Mon, 24 Jul 2017 09:21:56 GMT

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

avinashelite — Mon, 24 Jul 2017 09:22:17 GMT

Could you share the sample EXCEL