6 Replies Latest reply: Aug 28, 2015 1:30 PM by Harshit Bhatia RSS

    Filter specific expression result

      Hi,

       

      New to Qlik Community.

       

      Need some help on how to create a Listbox filter but using a specific result within an expression column.

      I remember briefly that you can make use of if(match(...) but cant get it to work to filter only a specific result.

       

      My expression reads as follows:

      if(Count(DISTINCT([Transaction date])) >3,'Multi Trn')

       

      I now need to create a filter to only show "Multi Trn" results

       

      Please help

       

      Thanks a mil