Number Format Issue

[#1]

Dear All,

My role in the firm starts from QLikview side, I dnt have edit privalages in BW. From BW we are getting KPI Measures as

for eg -200 as 200-. When I load the data in Qlikview, for all the '200-' types value Qlikview ignore the number and take it text. So negative values are getting ignored in aggregation, Sum functions.

Pls guide if there is some work around

Thanks

Tarun

[thomas_skariah]

Hi Tarun,

Need some info, is it from BW itself it is coming as for -200 as '200-'?

Regards,

Tom

[#3]

Hi Tom

yes, From BW we are exporting the files into CSV and in CSV we have '200-'

Regards

Tarun

[Sokkorn · Accepted solution]

Hi Rarun,

Let play with this expression in load script:

If(Index(FieldBW,'-')>1,PurgeChar(FieldBW,'-')*-1,FieldBW) as [FieldBW];

Or

If(IsText(FieldBW),PurgeChar(FieldBW,'-')*-1,FieldBW) as [FieldBW];

Regards,

Sokkorn

[Sokkorn]

Dear Tarun,

Sorry for spelled your name wrong.

With warm regards,

Sokkorn

[thomas_skariah]

Hi Tarun,

As per Sokkorn's code here is an example (attached).

Regards,

Tom

[#7]

Dear Sokkorn

Both of them Work. Thanks

Regards

Tarun