Discussion Board for collaboration on QlikView Scripting.
I have some series like this
Now I want only those number which start from IWG11 and IWG12.
How I can do it from edit script.
Thanks & Regards,
Go to Solution.
FROM TABLE where FIELD like 'IWG11*' or FIELD like 'IWG12*';
You can try somthing like this,
where left(Data,5) = 'IWG11' OR left(Data,5) = 'IWG12';