10 Replies Latest reply: Oct 17, 2016 11:16 PM by Bill Salalima RSS

    How to resolve Price Movement?

    Bill Salalima

      Hi Everyone,

       

      I have this concern regarding price movement. I have two available tables: one is a sales data, the other one is a price history. I don't know yet what should I need to do to resolve the scenario. This is to know if the certain SKU is a REGULAR or REDUCED during the Sales Date.

       

      SALES TABLE:

      Sales.JPG

       

      PRICE MOVEMENT TABLE:

      PM.JPG

       

      ** Take note that in DATE TO the value has 999999 meaning that it is the current price of the SKU, or you can set it as Today().

       

      Find below the desired output:

      SalesTag.JPG

       

      ** Since this is QlikSense (to be displayed in). Would it be possible to done the solution in the script? Not in the formula? I was thinking to comeup a Price Movement masterlist where it is breakdown daily.

       

      Thanks ahead for the help!

       

       

       

      Regards,

      Bill