Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jim_chan
Specialist
Specialist

How to display new and deleted records using expression?

Hi guys,

I have 2 years of data loaded in. Now client want to know what is the created record_id. But unfortunuatelty, under status - there's no value of "NEW" but just have 'deleted' and 'active'

So, how to  display new records using expression?

sccreenshot.jpg

Rgds,

Jim

20 Replies
sunny_talwar

This seems to be working in the posted example. Don't seen any impact of selections.

=Count(DISTINCT {1<Record_ID = e({1<Record_ID = {"=Count({1<Year = {'<$(=Max({1}Year))'}>} Record_ID) > 0"}>})>} Record_ID)

Would be able to share an example where this isn't working?

Capture.PNG

jim_chan
Specialist
Specialist
Author

remote to my laptop can ?

sunny_talwar

Remote to your laptop can? Not sure I understand bro

jim_chan
Specialist
Specialist
Author

=Count(DISTINCT {1<Record_ID = e({1<Record_ID = {"=Count({1<Year = {'<$(=Max({1}Year))'}>} Record_ID) > 0"}>})>} Record_ID)



for my actual object, it required filter by a_rating_name = 'LOW', b_rating_name = 'LOW', so in the above expression , do i need to add this 2 fields in?

jim_chan
Specialist
Specialist
Author

remote to my laptop. instead of providing the sample here. thats what i mean bro

sunny_talwar

Sure, I would add all filter that you might use

jim_chan
Specialist
Specialist
Author

can you give me example. where to add in these fields?

sunny_talwar

May be here:

=Count(DISTINCT {1<Record_ID = e({1<Record_ID = {"=Count({1<Year = {'<$(=Max({1}Year))'}>} Record_ID) > 0"}>}), a_rating_name = {'LOW'}, b_rating_name = {'LOW'}>} Record_ID)

jim_chan
Specialist
Specialist
Author

Sunny bro,

Not sure you know how to do this or not. There is 1 more requirement i am still do not know how to do.

- No. of records that changes detail in Category and Location. and what are those fields.

base on the example.qvw .

sunny_talwar

I am not sure I follow bro. There are too many things you are asking and I am not even sure if anything has been resolved yet or we are still dealing with the same issue?