topic Month to Month comparison in QlikView

Month to Month comparison

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

Hi All,

I need to compare month to month data and calculate the difference between the current and the prior month :

Code | Period | Sales | Diff

----------------------------------------------------------------------------------------

11 | 201801 | 2100 | 0

11 | 201802 | 1800 | -300

11 | 201803 | 2600 | 800

11 | 201804 | 1100 | -500

11 | 201805 | 4100 | 3000

11 | 201806 | 6100 | 2000

I created those expressions but it doesn't work:

sum({<[Calendar Year/Month] = {"$(=Date(Addmonths([Calendar Year/Month],-1),'YYYYMM'))"}>} RB)

Can anyone help please ?

thanks

zebhashmi — Wed, 28 Feb 2018 17:04:48 GMT

try that

sum({<[Calendar Year/Month] = {">=$(=Date(Addmonths([Calendar Year/Month],-1),'YYYYMM'))<=$(=Date([Calendar Year/Month]),'YYYYMM'))"}>} RB)

sunny_talwar — Wed, 28 Feb 2018 17:29:43 GMT

Try this

Alt(Sum(RB) - Above(Sum(RB)), 0)

Alt(Sum(RB) - Above(TOTAL Sum(RB)), 0)

Anonymous — Thu, 01 Mar 2018 08:48:39 GMT

Hi,

thanks for the response but unfortnately it doesn't return any result.

Anonymous — Thu, 01 Mar 2018 08:51:27 GMT

Hi,

Thanks for your response.

it works