3 Replies Latest reply: Aug 5, 2013 12:35 PM by gidon david RSS

    filter data

    gidon david

      Hello

      i have a list a data in the enclosed excel file

      data is located in sheet A

      filter is located in sheet B

      the output needed is as written in sheet C ( filted the lines vakue in sheet B )

      how do i make it in qlikview commands

      thanks

      gidon

        • Re: filter data
          Nagaian Krishnamoorthy

          One method is the use of "as of" table approach. You may use the following script to build "as of" table. Define a Listbox for field B, and a Table Box for fields A and Val.

           

          Data:

          LOAD * Inline [

          A, Val

          1,10

          2,20

          3,30

          4,40

          ];

           

          Temp:

          NoConcatenate LOAD Distinct A Resident Data;

          Outer Join (Temp) LOAD A as B Resident Data;

           

          AsOfTable:

          NoConcatenate LOAD A,B Resident Temp Where A <> B;

          DROP Table Temp;

           

          You may explore the feasibility of using Actions for "OnSelect" field A.

          • Re: filter data
            Jonathan Brough

            You could also exclude the filter rows from the data load using a NOT EXISTS:

             

            Filter:

            LOAD

                      A AS ExcludeValue

            FROM [C:\BITechnical\QlikView\QlikCommunity\Copy of FILTER.xlsx] (ooxml, embedded labels, table is B);

             

            Data:

            LOAD

                      A,

                      B

            FROM [C:\BITechnical\QlikView\QlikCommunity\Copy of FILTER.xlsx] (ooxml, embedded labels, table is A)

            WHERE NOT EXISTS (ExcludeValue,A);

            DROP FIELD ExcludeValue;

             

            Jonathan