Discussion Board for collaboration related to QlikView App Development.
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.
so I only want to extract the 'lsk090' and 'lam110'
Yes use Left() function but change = '1' for = 'l' (L) or use commodin "*" something like this:
* Opc1 (Left)
* Opc2 (Commodin *)
Where production_line,1 like 'l*';
It is not working for some odd reason. Right now I have this,
from example.qvd (qvd)
and it is not fetching any lines from this table. It says '0 lines fetched'