Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Comparison between two years

Hello,

I attach a file with sample data for a case of comparison between years.

I specified data and the request.

Thanks for any help!

11 Replies
Miguel_Angel_Baeyens

See attached, using something like

Concat({< CODE = {FR}, YEAR *= {$(=Max(YEAR))} >} USER, ', ')

Anonymous
Not applicable
Author

I want to count new entries in 2014 with CODE "FR".

The result in this case is 2 i.e. YY and ZZ, because they are not in 2013 and they have code "FR".

KK is excluded beacuse its code is "WEB"

XX is excluded because is already in 2013.


Is it possible?