topic Re: Previous months figures in QlikView

Previous months figures

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

Hi,

I am trying to get the previous months figures based on reference to today's date in a text object, but it comes up with an error message.

Any ideas?

Thanks

techvarun — Wed, 26 Jul 2017 04:02:34 GMT

Please try the below set analysis

= sum({<MonthYear = {"$(=Date(MonthStart(Today())-1,'MM-YY'))"}>} Actual)

shamitshah — Wed, 26 Jul 2017 04:20:27 GMT

Thanks Varun,

That worked out quite well.