If i select JUN month, What employee count should come?
If i select MAY month, What employee count should come?
If i select MAY and JUN months, What employee count should come?
If Select MAY month employee count 1
if select JUN month employee count 1
if select MAY and JUN employee count 1 ,because of in MAY month employee relived
There is an other thread with same problem, Where i have suggested a solution. Please try that and let me know. Please follow that thread and close this https://community.qlik.com/thread/244977
I think your month filter is based on Releving date. What you can do is use =SubField(GetFieldSelections([Month],',',GetSelectedCount([Month])),',',GetSelectedCount([Month])) and find the maximum month being selected. Now you can create the first of that month using makedate, for ex you select May and June, the make date should return 06/01/2016, store it in a variable v_date . For count, use the expression