6 Replies Latest reply: Feb 17, 2018 12:45 AM by ABHIJIT PRADHAN RSS

    filter related problem in qlik

    ABHIJIT PRADHAN

      SELECT * FROM TABLE1 ,TABLE2,TABLE3

      WHERE

      TABLE1.PRODUCT_KEY=TABLE3.PRODUCT_KRY

      AND

      TABLE2.PRODUCT_PART.NO.=TABLE3.PRODUCT_PART_NO.

      AND

      ( TABLE1.INTP_TYPE  in ('i', 's', 'c')  and TABLE2.PRODUCT _PART_NO<> '20398'

      or TABLE1.INTP_TYPE in ('s', 'd')

      and TABLE2.PRODUCT_PART_NO.= '20398' );

       

      SO, my question is that, where i will use this filter condition.----

      TABLE1.INTP_TYPE  in ('i', 's', 'c')  and TABLE2.PRODUCT _PART_NO<> '20398'

      or TABLE1.INTP_TYPE in ('s', 'd')

      and TABLE2.PRODUCT_PART_NO.= '20398

        • Re: filter related problem in qlik
          Digvijay Singh

          Are you facing any problem if you use this as it is in the script load statement?

            • Re: filter related problem in qlik
              ABHIJIT PRADHAN

              Yes, actually, this is not single filter condition .

              I am telling you the original scenario.

               

              Load   PRODUCT_KEY from

              table.qvd;

              i

              load  PRODUCT_PART_NO, PRODUCT_KEY from

              table3.qvd;

               

              Load PRODUCT_PART.NO from

              table2.qvd;

               

              Now, where i will use this condition, If , i use this filter condition ----

              (TABLE1.INTP_TYPE  in ('i', 's', 'c')  and TABLE2.PRODUCT _PART_NO<> '20398'

              or TABLE1.INTP_TYPE in ('s', 'd')

              and TABLE2.PRODUCT_PART_NO.= '20398')

              • Re: filter related problem in qlik
                ABHIJIT PRADHAN

                I am telling you the original scenario.

                 

                Load   PRODUCT_KEY from

                table.qvd;

                i

                load  PRODUCT_PART_NO, PRODUCT_KEY from

                table3.qvd;

                 

                Load PRODUCT_PART.NO from

                table2.qvd;

                 

                Now, where i will use this condition, If , i use this filter condition ----

                (TABLE1.INTP_TYPE  in ('i', 's', 'c')  and TABLE2.PRODUCT _PART_NO<> '20398'

                or TABLE1.INTP_TYPE in ('s', 'd')

                and TABLE2.PRODUCT_PART_NO.= '20398')

              • Re: filter related problem in qlik
                Mark Ritter

                Since this is your load script that is the only data that will make it into your app.

                 

                If you then added filters for those fields on a sheet you would only see the values that you selected in the Where clause.

                  • Re: filter related problem in qlik
                    ABHIJIT PRADHAN

                    I am telling you the original scenario.

                     

                    Load   PRODUCT_KEY from

                    table.qvd;

                    i

                    load  PRODUCT_PART_NO, PRODUCT_KEY from

                    table3.qvd;

                     

                    Load PRODUCT_PART.NO from

                    table2.qvd;

                     

                    Now, where i will use this condition, If , i use this filter condition ----

                    (TABLE1.INTP_TYPE  in ('i', 's', 'c')  and TABLE2.PRODUCT _PART_NO<> '20398'

                    or TABLE1.INTP_TYPE in ('s', 'd')

                    and TABLE2.PRODUCT_PART_NO.= '20398')

                     

                    So, you are saying that, i have to use this condition into sheet.

                    IN that case, i have product_part_number column into my app sheet, so how can i write the fileld expression into this particular column.---PRODUCT_PART_NO.

                    • Re: filter related problem in qlik
                      ABHIJIT PRADHAN

                      can i use this expression:------

                      if(match(invc_flag,'i','s','c') or  NOT match(invc_flag,'s','d'),product_part_no.,'20398')