Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikwiz123
Creator II
Creator II

Single field comparison based on month

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.

3 Replies
luismadriz
Specialist
Specialist

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];


Untitled.png

Untitled.png

Untitled.png

I hope this helps,

Cheers,

Luis

MayilVahanan

Hi

Can you provide some sample data with excepted result.

Thanks & Regards,
Mayil Vahanan R
shiveshsingh
Master
Master

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