topic Previous month sales in QlikView

Previous month sales

kamielrajaram — Wed, 23 Oct 2019 08:33:12 GMT

Hi all,

Please assist with generating straight table like below.

I need to show the previous month value In line with the month end . Any suggestions.

Month end current month previous month
31/03/2019 25.91
30/04/2019 2 6.63 2 5.91
31/05/2019 2 .87 2 6.63
30/06/2019 224.15 2 .87
31/07/2019 271.29 224.15

Thank you

Regards

Kamiel

Re: Previous month sales

kamielrajaram — Wed, 23 Oct 2019 10:14:25 GMT

Hi all,

Apologies,I thought it was resolved by using the above function. But when I select a specific month end date I lose the value for the previous month. This has not been resolved.

Thank you

Re: Previous month sales

sunny_talwar — Wed, 23 Oct 2019 11:33:09 GMT

Try something like this

Above(Sum({<Month, MonthEnd, Date>}Sales)) * Avg(1)

Be sure to add all the date and time fields where you might make a selection.

Re: Previous month sales

kamielrajaram — Thu, 24 Oct 2019 21:16:38 GMT

Hi Sunny,

Thank you. I managed to do this in the script.

Kind Regards

Kamiel