Removing data while loading in QlikView

[khan_imran]

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 !

[Anil_Babu_Samineni]

instead of No Data what are you trying to place?

[khan_imran]

null or - is fine.

[Anil_Babu_Samineni · Accepted solution]

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;