topic Re: Single field comparison based on month in QlikView

Single field comparison based on month

qlikwiz123 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Single field comparison based on month

luismadriz — Wed, 03 Jan 2018 03:34:43 GMT

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

Re: Single field comparison based on month

MayilVahanan — Wed, 03 Jan 2018 06:06:43 GMT

Can you provide some sample data with excepted result.

Re: Single field comparison based on month

shiveshsingh — Wed, 03 Jan 2018 06:20:49 GMT

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