Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jim_chan
Contributor III

how to display no.of new & deleted records?

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

2 Replies
MVP
MVP

Re: how to display no.of new & deleted records?

if you alreade have  the status field maybe

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

jim_chan
Contributor III

Re: how to display no.of new & deleted records?

oooook... Max..

but how about

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


Rgds


Jim