5 Replies Latest reply: Aug 11, 2017 11:33 AM by Sunny Talwar RSS

    Is it possible and how to use arithmetic operations over selected values and set result of these operations as a value in Set Expression?

    Dima OStrovsky

      Have same weekly data and task to make a report for previous week relative to selected one.

       

       

      Get data for selected week is easy task:

      Sum({$<[WeekStartDate] = $([WeekStartDate])>}

       

       

      // some complicated calculation here

      )

       

      For previous week hoped following code will do but failed:

      Sum({$<[WeekStartDate]={"$(=(Num([WeekStartDate])))-7"}>}

        

      // some complicated calculation here

      )

       

      I'm relatively new to Qlik Sense, so will be grateful for any help.