Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Create a table with the first 5 columns as dimensions and use this as an expression
=If(Count(Month) > 1, Count(Month))
Posted a QlikView screenshot, but should work the same way in Qlik Sense