topic Re: Number Format Issue in QlikView

Number Format Issue

Fri, 31 May 2013 01:56:50 GMT

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

Re: Number Format Issue

thomas_skariah — Fri, 31 May 2013 02:39:28 GMT

Hi Tarun,

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

Regards,

Tom

Re: Number Format Issue

Fri, 31 May 2013 02:44:05 GMT

Hi Tom

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

Regards

Tarun

Re: Number Format Issue

Sokkorn — Fri, 31 May 2013 02:56:04 GMT

Hi Rarun,

Let play with this expression in load script:

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

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

Regards,

Sokkorn

Re: Number Format Issue

Sokkorn — Fri, 31 May 2013 02:57:43 GMT

Dear Tarun,

Sorry for spelled your name wrong.

With warm regards,

Sokkorn

Re: Number Format Issue

thomas_skariah — Fri, 31 May 2013 03:43:12 GMT

Hi Tarun,

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

Regards,

Tom

Re: Number Format Issue

Fri, 31 May 2013 03:43:22 GMT

Dear Sokkorn

Both of them Work. Thanks

Regards

Tarun