2 Replies Latest reply: Aug 22, 2017 5:21 AM by Ryan Davies RSS

    Sum and Percentage Diff Between Two Max Dates Within Range

    Ryan Davies

      Hello Qlik Community,

       

      In a nutshell I have 5 week ending dates as a dimension. From these 5 week ending dates (Friday) I want to select the latest 2 within the range and calculate the sum difference between them and also the percentage difference as two separate KPI's.

       

      I've had a look online at other topics but I'm finding it difficult to apply the logic to my specific example.

       

      Thanks for any help