Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a requirements of Filtering out data from the search box. But i dont know if there's any option to do that in qlikview.
The sample Expression is:
=If(Match(Left([Code],3),'GCQ'),[Company])
Tried that in the List of fields option in general tab, doesnt work.
Any help?
Regards,
BC
You could use such expression within a listbox but not within a searchbox which could not return fieldvalues else it just filters the whole dataset / respectively the applied fields for a matching. In your case it seems not necessary to use such expression because just typing GCO* should be enough.
- Marcus
You could use such expression within a listbox but not within a searchbox which could not return fieldvalues else it just filters the whole dataset / respectively the applied fields for a matching. In your case it seems not necessary to use such expression because just typing GCO* should be enough.
- Marcus