topic Re: Problem in multiple selection in QlikView

Problem in multiple selection

praveenkumar_s — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

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

Re: Problem in multiple selection

muthukumar77 — Thu, 05 Jan 2017 07:19:08 GMT

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?

Re: Problem in multiple selection

praveenkumar_s — Thu, 05 Jan 2017 07:24:17 GMT

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

Re: Problem in multiple selection

parimikittu — Thu, 05 Jan 2017 07:29:38 GMT

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

Re: Problem in multiple selection

prat1507 — Thu, 05 Jan 2017 07:46:05 GMT

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

Re: Problem in multiple selection

prat1507 — Thu, 05 Jan 2017 07:59:27 GMT

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

Regards

Pratyush

Re: Problem in multiple selection

praveenkumar_s — Thu, 05 Jan 2017 08:38:36 GMT

hi,

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

Re: Problem in multiple selection

prat1507 — Thu, 05 Jan 2017 08:44:33 GMT

OK. PFA the screenshots.

Regards

Pratyush

Re: Problem in multiple selection

praveenkumar_s — Thu, 05 Jan 2017 08:49:17 GMT

Hi,

The screenshots is not getting ..

Re: Problem in multiple selection

praveenkumar_s — Thu, 05 Jan 2017 09:17:35 GMT

Hi,

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

Re: Problem in multiple selection

vinieme12 — Thu, 05 Jan 2017 10:35:45 GMT

Create a Variable as below, WITHOUT EQUAL sign

using Pratyush's sample

vDateIS : MonthStart(Max(TOTAL Date))

and use the same in Expression

=count({< Emp_ID = {"=Releving_Date < $(vDateIS)"} >} Emp_ID)

Re: Problem in multiple selection

prat1507 — Thu, 05 Jan 2017 12:36:15 GMT

Hi Praveen

Are you not able to open the screenshots? You need to extract those files. Do one thing, call me on 7045114315.

Regards

Pratyush