how to display no.of new & deleted records?

[jim_chan]

Hi guys,

Yesterday i have posted up question at

https://community.qlik.com/message/1139924?et=watches.email.thread#1139924

Basically, there are such requirements:

- Display no. of new & deleted records for Year 2016.

- Display current(2016) no. of records that have changes in column Category & Location compare to previous year.

Yesterday, with the help of peopl in comuunity , we had solved 'display no. of records that have made changes over the total of number records'

Rgds

Jim

[maxgro]

if you alreade have  the status field maybe

=count({$ <Status={New,Deleted}, Year={2016}>} Record_ID)

[jim_chan]

oooook... Max..

but how about

- Display current(2016) no. of records that have changes in column Category & Location compare to previous year.?

Rgds

Jim