How to do Sum with in the count in set analysis

[lakshman1031]

Hi All,

I have data like

ID	Year Month	hours	Workdays
10001	Nov-24	1	21
10002	Nov-24	2	21
10003	Nov-24	4	21
10004	Nov-24	5	21
10005	Nov-24	6	21
10006	Nov-24	7	21
10007	Nov-24	8	21
10008	Nov-24	9	21
10009	Nov-24	6	21
10010	Nov-24	7	21
10011	Nov-24	8	21
10012	Nov-24	8	21
10013	Nov-24	7	21
10014	Nov-24	6	21
10015	Nov-24	7	21

hours i am taking

hour = sum(hours)

Base Line hours = Workday*7.5 

in Nov - 21*7.5 = 157.5

Minimum hours = sum(hourd)

I am trying to count the ides

in tableau is having

count(if(baseline hours>=Minhours then ID)

I am trying to use in Qlik side

Count(aggr(if(Sum(hour)>=workdays*7.5 ,'Yes'),ID))

i am using current month it will work but if i am selecting any selections it won't work.

I am using same formula in line chart it will display only current month.

My Requirement is for example workday *7.5 then having 157.5 and we need to count the id's like more then 157.5 >= sum(hours) how many id having.

Can you please suggest me how to do this scenario in Qliksense.

Thanks & Regards,

Lakshman

[Aurelien_Martinez]

Hi,

You can try a expression like :

Count({<ID={"=Sum(Hours*Workdays)>Sum(Workdays)*7.5"}>} ID)

Aurélien