topic Re: LAST MONTH VALUE in QlikView

LAST MONTH VALUE

sagaraperera — Wed, 25 Nov 2020 16:16:04 GMT

Dear All I Select year 2019 and month of September and i want to get a value of 2019 august value please help sagara

sudhirpkuwar — Wed, 23 Oct 2019 11:09:41 GMT

Try Addmonths()

For eg. Addmonths(max(<Date Field>),-1) will give you previous of month selected

Brett_Bleess — Thu, 31 Oct 2019 18:23:56 GMT

The following Design Blog links may provide some further ideas too:

Regards,
Brett