topic Re: Set Analysis intersection in the same field in App Development

Set Analysis intersection in the same field

Milutin — Tue, 17 Sep 2019 13:47:36 GMT

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

Re: Set Analysis intersection in the same field

sunny_talwar — Tue, 17 Sep 2019 13:54:03 GMT

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 🙂

Re: Set Analysis intersection in the same field

Milutin — Tue, 17 Sep 2019 14:07:48 GMT

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

Re: Set Analysis intersection in the same field

Milutin — Wed, 18 Sep 2019 07:54:31 GMT

I was thinking something like :

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

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

Is it possible to do it like this?

Re: Set Analysis intersection in the same field

sunny_talwar — Wed, 18 Sep 2019 11:18:40 GMT

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?

Re: Set Analysis intersection in the same field

Milutin — Wed, 18 Sep 2019 11:21:46 GMT

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

Re: Set Analysis intersection in the same field

sunny_talwar — Wed, 18 Sep 2019 11:50:43 GMT

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

Re: Set Analysis intersection in the same field

Milutin — Wed, 18 Sep 2019 11:57:00 GMT

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

Re: Set Analysis intersection in the same field

sunny_talwar — Wed, 18 Sep 2019 11:59:19 GMT

Is this for QlikView or Qlik Sense?

Re: Set Analysis intersection in the same field

Milutin — Wed, 18 Sep 2019 12:00:13 GMT

Qlik sense

Re: Set Analysis intersection in the same field

sunny_talwar — Wed, 18 Sep 2019 12:03:47 GMT

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

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

Re: Set Analysis intersection in the same field

sunny_talwar — Wed, 18 Sep 2019 12:04:19 GMT

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