Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
amit_saini
Master III
Master 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
Master
Master

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
Champion
Champion

Or simply:

...

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