Problem in multiple selection

[praveenkumar_s]

Hi,

I have attached document facing the problem in master calendar ,i hope that could you please give me replay as soon as possible.

[muthukumar77]

Hi,

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?

[praveenkumar_s]

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

[parimikittu]

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

[prat1507]

Hi praveen

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

Count({<Releving_Date={'>=v_date'}>}Emp_ID).

Problem solved.

Regards

Pratyush

[prat1507]

PFA the .qvw for your reference. It is way too simple than I thought.

Regards

Pratyush

[praveenkumar_s]

hi,

I'm using personal edition so i cannot able to open the file.Kindly send the snapshot of how to do it..

[prat1507]

OK. PFA the screenshots.

Regards

Pratyush

[praveenkumar_s]

Hi,

     The screenshots is not getting ..

[praveenkumar_s]

Hi,

     I'm not getting clarity what you told, plz explain clearly