topic Re: Roll Back script in QlikView

Roll Back script

Anonymous — Wed, 17 Feb 2016 16:38:21 GMT

I have data like this

date sales

21/1/2016 500

22/1/2016 600

28/1/2016 700

31/1/2016 800

2/2/2016 1000

3/2/2016 1200

i want to roll back last 5 days sales how it is possible ? my max date was 3/2/2016 .

kaushiknsolanki — Thu, 18 Feb 2016 16:58:28 GMT

Hi,

You can use this expression.

Sum({<Date = {">=$(=Max(Date)-5)"}>}Sales)

Regards,

Kaushik Solanki

sunny_talwar — Thu, 18 Feb 2016 17:07:41 GMT

Kaushik, I would add the date function in the set analysis to make sure the formatting is the same:

Sum({<Date = {">=$(=Date(Max(Date)-5), 'YourDateFieldFormatHere')"}>}Sales)