2 Replies Latest reply: Jul 14, 2016 6:43 AM by Håkan Augustsén RSS

    ariables in set analysis

    Håkan Augustsén

      Using variables in set analysis in Qlik Sense 3

      Trying to plot graf limited from todays week and forward

      Browsing the forum I found excellent tips that supposed to work but unfortunately they don’t

      Defined the variable:

      LET vWeekCurrent = Week(Today());

      Formula:

      Sum({$<Week={$(>vWeekCurrent)}>}([Amount 2015])

       

      Don’t get it how to achieve greater than vWeekCurrent in the set
      Data is two columns Week and Amount 2015

      This works fine with

      Sum({$<Week={“>27”}>}([Amount 2015])