Discussion Board for collaboration on QlikView Scripting.
I have a 'problem' related to filtering records. I have a dataset like:
now I have created a combobox (using the LOAD * INLINE function ) with all activities. Selecting the activities in the combobox should result in a filter on the dataset.
I need to create a sort of OR-statement....but I have no idea where to start. Most filters are based on the AND-statement (selecting act. 1 and act. 2 would result only in b1).
Anyone an idea?
Thanks in advance.
Go to Solution.
If you select, for example, act.1 and act.2 in one list box, then the filter will be an OR filter be default; so values matching act.1 or act.2 will be returned.
Create a filterbox from the source data rather than in INLINE so that it is linked to the data.
You just need to convert your first given table into a Cross Table. and that will do the trick.
Hope it helps
thanks for the fast reply. It works perfectly. My dad used to say Keep It Simple St...and this time I again allmost created a complex solution for such a simple problem.