Discussion Board for collaboration on QlikView Scripting.
I need filter help while loading the data. I'm trying below condition to not load the POSID where last digits are '000'
where POSID <> right(POSID, 3) like '000'
and second how to select a range KSTAR = 5000000 to 9999999 in where condition.
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