2 Replies Latest reply: Oct 19, 2017 2:56 AM by Jon von der Heyden RSS

    Filter a table

    Jon von der Heyden

      Hi

       

      Qlik noob - tried searching but perhaps not aware of what lingo to use just yet.

       

      I have a table and I would like to filter it according to 1 specific field, without using Selections / Filter Pane (i.e. a constant parameter).  I also don't want to add the parameter field to the table.

       

      So say I have dozens of fields.  I have a field called [QRT] but I do not add this to the table.  I would like the table to only display records where [QRT] = 'S0602'.

       

      Can someone offer me a steer please?

       

      Thanks

      Jon

        • Re: Filter a table
          Felip Drechsler

          Hi Jon,

           

          You'd have to use set analysis for that.

           

          As an example, say you want the sum of sales for the QRT field equal to S0602, you would need to do the following:

          sum({<QRT={'S0602'}>}Sales)

           

          The bolded part {<QRT={'S0602'}>} would be the "filter" based on some criteria you want, even though you didn't select anything and the field is not on your table.

           

          Felipe.

            • Re: Filter a table
              Jon von der Heyden

              Hi Felipe

               

              Thank you for your suggestion.  However in this case I do not want to aggregate any numeric results.  Mine is a table of text values and I want to limit records according to a criterion.  QRT is a field (not in table) and I want to only show records that are associated where [QRT] = 'S0602'.

               

              Thanks

              Jon