Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

Number Format Issue

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

1 Solution

Accepted Solutions
Highlighted
Sokkorn
Honored Contributor

Re: Number Format Issue

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

View solution in original post

6 Replies
Highlighted
thomas_skariah
Contributor III

Re: Number Format Issue

Hi Tarun,

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

Regards,

Tom

Highlighted
Not applicable

Re: Number Format Issue

Hi Tom

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

Regards

Tarun

Highlighted
Sokkorn
Honored Contributor

Re: Number Format Issue

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

View solution in original post

Highlighted
Sokkorn
Honored Contributor

Re: Number Format Issue

Dear Tarun,

Sorry for spelled your name wrong.

With warm regards,

Sokkorn

Highlighted
thomas_skariah
Contributor III

Re: Number Format Issue

Hi Tarun,

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

Regards,

Tom

Highlighted
Not applicable

Re: Number Format Issue

Dear Sokkorn

Both of them Work. Thanks

Regards

Tarun