topic Re: Removing data while loading in QlikView in QlikView

Removing data while loading in QlikView

khan_imran — Wed, 07 Jun 2017 16:53:45 GMT

Hello All,

I have requirement to remove No Data from all the columns available in the data.

Attached is the sample data with App.

Is there any way to achieve this?

Regards,

Imran Khan !

Re: Removing data while loading in QlikView

Anil_Babu_Samineni — Wed, 07 Jun 2017 16:56:04 GMT

instead of No Data what are you trying to place?

Re: Removing data while loading in QlikView

khan_imran — Wed, 07 Jun 2017 17:05:00 GMT

null or - is fine.

Re: Removing data while loading in QlikView

Anil_Babu_Samineni — Wed, 07 Jun 2017 17:13:29 GMT

One simplest way is this?

Data:

LOAD Key, If(A='No Data','-', A) as A, If(B='No Data','-', B) as B, If(C='No Data','-', C) as C INLINE [

Key, A, B, C

A, No Data, 1, 2

B, 2, No Data, 5

C,4, 4, No Data

];

EXIT SCRIPT;

OR

Set Nullinterpret = 'No Data';

NULLASVALUE *;

Set NullValue = '-';

Data:

LOAD * INLINE [

Key, A, B, C

A, No Data, 1, 2

B, 2, No Data, 5

C,4, 4, No Data

];

EXIT SCRIPT;