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]

Create a table with the first 5 columns as dimensions and use this as an expression

=If(Count(Month) > 1, Count(Month))

 

[sunny_talwar]

Posted a QlikView screenshot, but should work the same way in Qlik Sense