Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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';

Community Browser