2 Replies Latest reply: Aug 30, 2016 2:06 PM by patrico mesri RSS

    Load Data: Only Load columns that have an specific value under other column

    patrico mesri

      Hi Community, hope someone can help me out with this.

       

      I have an excel with the following info:

       

      CompanyCodeItemOwnerPriceCurrencyAmountQ
      5000199999BananasPatrick401EUR290000
      5000200493OrangesMathew394EUR29500
      5100224004ApplesLouis330USD300000
      5400303404Ice CreamChristian502USD503000

       

      Before loading the data to Qlik, I want to Load ALL coumns but only when the CODE column is between 200000 and 299999.

       

       

       

      Once uploaded to Qlik, this should be the only visible data:

       

      CompanyCodeItemOwnerPriceCurrencyAmountQ
      5000200493OrangesMathew394EUR29500
      5100224004ApplesLouis330USD300000

       

      Thank you in advance.

      Regards.