Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
praveenkumar_s
Contributor II

Problem in multiple selection

Hi,

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

11 Replies
Highlighted
Partner
Partner

Re: Problem in multiple selection

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?



Muthukumar Pandiyan
Highlighted
praveenkumar_s
Contributor II

Re: Problem in multiple selection

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

Highlighted
parimikittu
Contributor II

Re: Problem in multiple selection

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

Highlighted
prat1507
Valued Contributor

Re: Problem in multiple selection

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

Highlighted
prat1507
Valued Contributor

Re: Problem in multiple selection

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

Regards

Pratyush

Highlighted
praveenkumar_s
Contributor II

Re: Problem in multiple selection

hi,

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

Highlighted
prat1507
Valued Contributor

Re: Problem in multiple selection

OK. PFA the screenshots.

Regards

Pratyush

Highlighted
praveenkumar_s
Contributor II

Re: Problem in multiple selection

Hi,

     The screenshots is not getting ..

Highlighted
praveenkumar_s
Contributor II

Re: Problem in multiple selection

Hi,

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