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!

       

      best,

       

      Rustam