Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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!



Community Browser