how to remove if field= 0 or negative qlikview

[bsbernabe]

Hello There,

my concern is how to remove if field= 0 or negative QlikView?

below is the sample data

Account	Data
123	abcd123
456	efgd456
789	-
101	hijk789
111	qwer987
112	hnyk096
113	0

Best Regards,

Bing

[Saravanan_Desingh · Accepted solution]

Can you try this?

LOAD * INLINE [
    Account, Data
    123, abcd123
    456, efgd456
    789, 
    101, hijk789
    111, qwer987
    112, hnyk096
    113, 0
    114, -5
]
Where Not IsNull(Data) And Data>0 And Data<>''
;

 The '-' might be Null representation.