Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'
i am think you are not following mr qlikview beginner:
try this:
left(production_line, = 'L' or 'l') where 1;
your friend - KILGORE WATTS
hello qlikview beginer,
please give my answer considration it is due and give helpful. thanks
your friend - KILGORE WATTS
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.
i see how is
your friend - KILGORE WATTS