topic Re: Max Period - 1 Not Working in QlikView

Max Period - 1 Not Working

Anonymous — Wed, 08 Nov 2017 15:40:36 GMT

I have periods in my data set formatted as 11/1/2017

The max period calculation is working

PERIOD = {"$(=Max(PERIOD))"}

But the previous period calculation is not

PERIOD = {"$(=Max(PERIOD)-1)"}

Any pointers here?

Thank you,

- dave

YoussefBelloum — Wed, 08 Nov 2017 15:46:09 GMT

Hi,

what do you want exatly when you say -1 ? day -1, month -1, year -1 ?

Anonymous — Wed, 08 Nov 2017 15:58:20 GMT

So the periods are set up in a monthly fashion ... i.e

1/1/2017

2/1/2017

3/1/2017

etc ...

I want to sum({< PERIOD = {"$(=Max(PERIOD)-1)"}>} AMT)) ... so if the max period is 3/1/2017 I want to return AMT for 2/1/2017

sunny_talwar — Wed, 08 Nov 2017 16:04:06 GMT

So, essentially you are going back a month? May be this

PERIOD = {"$(=AddMonths(Max(PERIOD), -1))"}

vinieme12 — Wed, 08 Nov 2017 16:55:05 GMT

when you do math operation on a date value the resultant will be an Integer value, so there is a data type mismatch

to avoid that you must specify your date format for the field PERIOD

example

$(=DATE(Max(PERIOD)-1))) or $(=DATE(Max(PERIOD)-1,'DD/M/YYYY'))

Anonymous — Wed, 08 Nov 2017 18:32:34 GMT

Works perfect thank you !!!