Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
if you alreade have the status field maybe
=count({$ <Status={New,Deleted}, Year={2016}>} Record_ID)
oooook... Max..
but how about
- Display current(2016) no. of records that have changes in column Category & Location compare to previous year.?
Rgds
Jim