Set analysis

[Mahamed_Qlik]

Dear all,

We want to display only records in same month and with Type (56 and 59).

We need to consider only highlighted records but we are getting other records as well.

Expression :

"Count({<Type={'56','59'},EMP_ID= P({<Type={'56'},Month={"=below(Month)"}>} EMP_ID)*P({<Type={'59'},Month={"=below(Month)"}>} EMP_ID),Flag-={}
>} distinct EMP_ID)"

[Rohan]

Hi Mahamed,

I suggest you create the flag in the backend, it will be very simple to handle it that way. You simply need to do is :

Temp :

Load 

EMP_ID&'|'&Month as Key,

Count(distinct Type) as NewFlag

Resident Data where Wildmatch(Type,'56','59');

& in the front end Use :

Count({<NewFlag={"2"}>}distinct EMP_ID)

Let me know if it works for you.

Regards,

Rohan.

[Mahamed_Qlik]

Thanks Rohan for your information but we want to handle this in front end only.

because we have many Types..not just 56&59

[Rohan]

Hi,

Try this, but this will work when you select a Month :

sum(if(aggr(count({<Type={"56","59"},Month={"$(=Date(max(date#(Month,'MMM')),'MMM'))"}>}distinct Type),EMPID)=2 and
aggr(count({<Month={"$(=Date(max(date#(Month,'MMM')),'MMM'))"}>}distinct Month),EMPID)=1,
1,0))

Regards,

Rohan.