2 Replies Latest reply: Nov 17, 2015 2:09 PM by Rob Wunderlich RSS

    Help with filtering unwanted data in load script?

    Ryan Minaker

      Hi,

       

      I have a column with multiple values in each field. I only want to report on certain values (e.g., Apple and Banana).


      Fruit

      Apple, Pear, Peach

      Banana, Orange, Apple

      Peach, Tomato, Kiwi

      Apple, Orange, Peach

       

      Within my app, I've been able to filter out the values I don't want using set analysis like this (and I'm getting the right result):

       

      [Fruit]={

      '*Apple*',             

      '*Banana*'

      }

       

      The problem is this causes some headaches when I'm trying to drill down using filters (I've connected some other tables with the [Fruit] column as well).

       

      Can someone let me know if there's a way to filter out the unwanted values in the load script so none of the fruits I don't want are being loaded at all? I've searched the forums for Qlik Sense and Qlik View and have tried using the Wildmatch function, but I can't seem to get it work.

       

      Any help would be much appreciated, and thanks!