0 Replies Latest reply: Apr 9, 2015 8:27 AM by rustam mashrapov RSS

    Variables in Qlik Sense

      Hi all,


      I have a data on a seconds level, (1 Feb 2015 12:30:13), have created a date using ceil operations ( 1.Feb 2015)


      I have learned that there are previous() built in function in Qlik Sense, that would take the value of previous row (t-1)


      I want to create a variable of a key figure ( for sales amount) and compare it with the average of previous months, weeks, or days.


      Avg(Sales Amount(t-1)+Sales Amount(t-2)), where t might be month, or week, or a fortnight or a day.


      many thanks for your help!