1 Reply Latest reply: Feb 3, 2016 12:39 PM by Sunny Talwar RSS

    Qlik Sense Filter Within an Expression

    Feras Alsuhaibani

      Hello Everyone!

       

      So I have this expression, and I was wondering if there is a way to use a filter within that expression. For example:

       

      this is my expression:

       

      Count({$< StatusesId = {1}, ItemsCon -={16}>} distinct RequestId)

       

      So what I would like to do is to provide a user with a filter so that the user can choose "ItemCon"; I would like to enable the user to either choose nothing: so the expression will be like:

       

      Count({$< StatusesId = {1}, >} distinct RequestId)

       

      or allow the user to specify a value for ItemCon to be excluded:

       

      Count({$< StatusesId = {1}, ItemsCon -={16}>} distinct RequestId)

       

      or allow the user to specify a value for ItemCon to be included:

       

      Count({$< StatusesId = {1}, ItemsCon ={16}>} distinct RequestId)

       

      Your help is appreciated!

      Thanks!