4 Replies Latest reply: Mar 2, 2018 10:04 PM by Tauceef Sheikh RSS

    How to filter data based on hardcoded filter

    Tauceef Sheikh

      Hello Everyone,

       

      I have a requirement wherein I have to create a Hardcoded filter like below:

      ValueList('A','B','C')

       

      And as per the value selected by user in the above filter I have to modify the data of a particular table (not the overall application).

       

      Please suggest if there's any way of doing this.

       

      Qliksense Version: QS Desktop June

       

      Regards,

      Tauceef

        • Re: How to filter data based on hardcoded filter
          Jaume Criballés Faja

          Try something like this:

           

          if(ValueList('A','B','C')='A', formula A',

               if(ValueList('A','B','C'))='B', formula B', formula C'))

            • Re: How to filter data based on hardcoded filter
              Tauceef Sheikh

              Hi Jaume,

               

              Thanks for your response.

               

              I tried this code but it is not working for me. As mentioned earlier we have created the hardcoded filter which is not linked with my data anywhere.

               

              Is there a way we can get the selected value of a particular filter in sense? so that will use it in my formula to do the calculations.

               

              I found one function "GetFieldSelections(dimention)" but this will not work in my case as I have created this filter using Listvalue() function.


              Looking forward for a work around.

               

              Edited:

              Just found one more thing, which is bad again.

              I have created the filter using Valuelist() function but when I select anything, no filter is getting applied.

               

              Now I think I have to start asking from one step backword:

              1. how to create a hardcoded filter with some values.

              2. how we can use this filter in any chart or table to filter data.

               

              Regards,

              Tauceef