topic Re: Previous and Current Month data comparison in QlikView

Previous and Current Month data comparison

Wed, 04 Nov 2015 13:42:51 GMT

Hi,

Please assist as I want to perform the following computation:

on my data set I have a field 'class' the holds two outcomes 'legal' and 'not legal'

I want to sum the total amount when:

- in the previous month, the accountNumber's class was 'not legal'

- and current month, the accountNumber's class is 'legal'

meaning i want to sum total amount for only the accountNumbers that have transitioned from not legal (in the previous month) to legal (current month)

Your assistance will be highly appreciated

Gysbert_Wassenaar — Wed, 04 Nov 2015 16:47:26 GMT

Please don't clutter this site with duplicate discussions: Previous and Current month comparisons

Thu, 05 Nov 2015 08:45:03 GMT

Good day,

Could I please get assistance...