topic Re: Filter data in QlikView

Filter data

amit_saini — Thu, 28 Sep 2017 15:27:51 GMT

Hi Folks,

I need filter help while loading the data. I'm trying below condition to not load the POSID where last digits are '000'

Examples :

C00001000

C00002000

C00003000

C00004000

C00005000

C00006000

where POSID <> right(POSID, 3) like '000'

and second how to select a range KSTAR = 5000000 to 9999999 in where condition.

Thanks,

effinty2112 — Thu, 28 Sep 2017 16:13:16 GMT

Hi Amit,

Maybe

WHERE NOT WILDMATCH(POSID,'*000')

for the other condition - KSTAR >= 5000000 AND KSTAR <=9999999.

If you're doing a preceding load from SQL then you can put this clause in the SQL SELECT statement instead:

WHERE KSTAR BETWEEN 5000000 AND 9999999

Good luck

Andrew

YoussefBelloum — Thu, 28 Sep 2017 16:18:29 GMT

Or simply:

...

Where right(POSID,3)<>'000';