Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
amit_saini
Honored Contributor III

Filter data

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,

AS

2 Replies
effinty2112
Honored Contributor

Re: Filter data

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
Esteemed Contributor

Re: Filter data

Or simply:

...

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