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: 
Not applicable

Excluding things from a field during load

Hi, I have a field where I have bunch of things that I don't need. How can I limit this?

For example, I have a field called production_line where I only need things that start with the letter L.

production_line

wsk090

lsk090

lam110

man102

so I only want to extract the 'lsk090' and 'lam110'

13 Replies
Not applicable
Author

i am think you are not following mr qlikview beginner:

try this:

left(production_line, = 'L' or 'l') where 1;

your friend - KILGORE WATTS

Not applicable
Author

hello qlikview beginer,

please give my answer considration it is due and give helpful. thanks

your friend - KILGORE WATTS

Not applicable
Author

Thank you Kilgore. I tried your response and it was giving me an error for some odd reason. The answer from Massimo from above has helped with this.

Not applicable
Author

i see how is

your friend - KILGORE WATTS