how to display no.of new & deleted records? - Qlik Community

jim_chan · ‎2016-10-12

Hi guys,

Yesterday i have posted up question at

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 · ‎2016-10-12

if you alreade have the status field maybe

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

jim_chan · ‎2016-10-12

oooook... Max..

but how about

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

Rgds

Jim