topic Comparison between current year and previous year in QlikView

Comparison between current year and previous year

Mon, 28 Jul 2014 13:04:54 GMT

Hi All,

I want to calculate from transaction data:

1> count of CODE which are present in current year but not in previous year i.e New Code.

2> count of CODE which are present in previous year but not in current year i.e Lost Code.

3> count of CODE which are present in both years.

Any help would be highly appreciated.

Kindly find the application for dummy data.

MK_QSL — Mon, 28 Jul 2014 13:26:17 GMT

='In Both Year : '&COUNT({<year = {'$(=Max(year))'}, CODE = P({1<year = {'$(=max(year)-1)'}>}CODE)>}DISTINCT CODE)

='In '&Max(year) & ' but Not '&(Max(year)-1) &': '&COUNT({<year = {'$(=Max(year))'}, CODE = E({1<year = {'$(=max(year)-1)'}>}CODE)>}DISTINCT CODE)

='In '&(Max(year)-1) & ' but Not '&Max(year) &': '&COUNT({<year = {'$(=Max(year)-1)'}, CODE = E({1<year = {'$(=max(year))'}>}CODE)>}DISTINCT CODE)