Single field comparison based on month

[qlikwiz123]

I have the below fields in my Data model:

Month

Users

My comparing month parameter is Jan

I need to show the Users that are present in Jan and the other months.

For example, for month of Feb, I need to show the Users that are present in both Jan and Feb (Common Users in these months). For Mar, I need to show the Users that are common in Jan and Mar.

Expression level calculation is requested.

[luismadriz]

Hi,

Not sure I fully understand the end result but here it's a first go to maybe get more expert attention.

This is what I'm using to load data:

// Users and Month

load * inline [

Users,Umonth

u1,Jan

u1,Feb

u1,May

u2,Jan

u2,Mar

u2,May

u3,Feb

u3,Mar

u3,Apr

u3,Jan

];

// Selection month: just to test different selections

load * inline [

Smonth

Jan,

Feb,

Mar,

Apr,

May,

Jun];

I hope this helps,

Cheers,

Luis

[MayilVahanan]

Hi

Can you provide some sample data with excepted result.

[shiveshsingh]

You can use a inner join in both the tables to get common data