5 Replies Latest reply: Dec 15, 2017 10:00 AM by Youssef Belloum RSS

    Applymap not working in QlikSense

    Ravindra Dhulipala

      Hi All,

       

      Hope everyone is doing good.

       

      I have an issue in applymap() in QlikSense.

       

      i have used below script but i am not getting the expected result. even though there are so many matching values between two tables i am getting 'No Supplier' as the value in the new derived column.

       

      I tested with Join and also normal association to see if there is any data type issue, but both of them are working fine.

       

      below is the script that i have used.

       

      Map:

      Mapping

      Load

         "Supplier Number",

          "Product Number"

         

      FROM [$(vQVDPath)Product.qvd]

      (qvd);

       

      Sales:

      Load

          "Product Number",

          ApplyMap('Map',"Product Number",'No Supplier') as Supplier

       

      FROM [$(vQVDPath)Sales.qvd]

      (qvd);

       

      any help would be highly appreciated.

       

      Thanks,

       

      Ravi