topic Re: Difference by month in QlikView

Difference by month

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

I have a data set that give me the open amount on my AR by month:

I would like to present this as the difference from last month:

I would also like this to change depending on the selection of months.

In the past I have always worked with a new data set for changes, but wondered whether there was a way to do this within an application.

devarasu07 — Fri, 18 Aug 2017 07:37:28 GMT

Hi,

Try like this,

sum(Value)-above([Value])

matthewjbryant — Fri, 18 Aug 2017 07:41:30 GMT

Thanks for the response. I can see how that would work if the table is sorted by Month, but it's nowhere near as robust as a new data set.

sunny_talwar — Fri, 18 Aug 2017 12:35:23 GMT

You can try this approach

matthewjbryant — Mon, 21 Aug 2017 07:45:09 GMT

Where the AsOf month relates to the month and the previous month? That's a great idea! I'll play around with this approach.