Set Analysis intersection in the same field

[Milutin]

Hello everyone,

This is a glimpse of my dataset:

I want to make a table within my app with set analysis to show what rows are the same for different months, but in a way that always compares current month with previous month, and also current month with a month before previous month. 

Basically I want to see the intersection between months, but since my table is updated monthly, I always need to compare current month with others, and I want to do so without specifically naming every month.

If I need to clarify more, please ask.

Thanks in advance.

Regards,

Milos

[sunny_talwar]

So, based on the input file showed, can you explain what the output needs to look like? Also, in what kind of object?

Best,
Sunny

P.S. it is better to upload an Excel file rather than an image of the Excel file because there is no way to load the data from an image 🙂

[Milutin]

Thanks for the quick response.

Output should look the same as input, also in a table in qlik.

here is a part of my dataset, but i think it will be enough

[Milutin]

I was thinking something like :

({<Month = {max(Month)}>}[Engagement Name])*({<Month = {Last(Month)}>}[Engagement Name])

or

{<Month = {max(Month)}>*<Month = {Last(Month)}>}[Engagement Name]

Is it possible to do it like this?

[sunny_talwar]

Output should look the same as input? You want to see all 44 rows in a single table? Then why do you need anything other than a table box? I am not sure I understand?

[Milutin]

Sorry, my bad, output should only show rows that are same for different months(same Engagement Leader, Engagement Name, etc...)

[sunny_talwar]

So, all you want to display is if the first 5 columns in your data repeats for more than a month?

[Milutin]

Basically yes, I want to see these 5 columns that are same for the current month and the previous month

[sunny_talwar]

Is this for QlikView or Qlik Sense?

[Milutin]

Qlik sense