topic Re: Problem in Multiple selection in mastercalender in QlikView

Problem in Multiple selection in mastercalender

Wed, 25 Nov 2020 16:16:04 GMT

I have uploaded my problem through attachment,

if any one know could you please give explanation through expressions

Regards,

Niranjan B

Re: Problem in Multiple selection in mastercalender

Miguel_Angel_Baeyens — Tue, 03 Jan 2017 16:30:46 GMT

At a first glance, I don't see any problem. If you select one month and there is only one row, count equals to 1. When you select two months and there are two employees, count is 2. What's wrong with that or what would you expect to see?

Re: Problem in Multiple selection in mastercalender

Wed, 04 Jan 2017 05:42:13 GMT

thanks for your replay

Re: Problem in Multiple selection in mastercalender

Wed, 04 Jan 2017 06:08:00 GMT

Niranjan, can you explain your problem clearly in it because as per the document we don't see anything wrong in it.

-Ashok

Re: Problem in Multiple selection in mastercalender

Wed, 04 Jan 2017 06:19:10 GMT

Selecting two months() need employee count Will be one,because in may month employee relieved,i want to show current employee count choosing multiple selection

Re: Problem in Multiple selection in mastercalender

Wed, 04 Jan 2017 06:19:27 GMT

Selecting two months() need employee count Will be one,because in may month employee relieved,i want to show current employee count choosing multiple selection

Re: Problem in Multiple selection in mastercalender

parimikittu — Wed, 04 Jan 2017 08:28:37 GMT

Hi, =Count({$(=MonthStart(max(Month)))"}>} Empid) Use the aboveformula in Employee Count.

Re: Problem in Multiple selection in mastercalender

Thu, 05 Jan 2017 05:54:23 GMT

Hi Miguel,

when i choose multiple selection want to show current employee status only,no need count of who are relieved employee's.

I hope that could you please give me replay as soon as possible.

Regards,

Niranjan

Re: Problem in Multiple selection in mastercalender

parimikittu — Thu, 05 Jan 2017 05:58:22 GMT

Hi Niranjan, Count({} Empid) Have u tried using this?

Re: Problem in Multiple selection in mastercalender

Thu, 05 Jan 2017 05:59:06 GMT

Hi vj kri,

not getting clarity,could you please explain clearly.

I hope that could you please give me replay as soon as possible.

Re: Problem in Multiple selection in mastercalender

parimikittu — Thu, 05 Jan 2017 05:59:50 GMT

Hi Niranjan,

//Count({$(=MonthStart(max(Month)))"}>} Empid)

not able to paste my answer

Re: Problem in Multiple selection in mastercalender

Thu, 05 Jan 2017 06:09:14 GMT

Hi,

It showing error after ending of month in the previous expression and one double quotes only present in your expression..If i tried to remove the double quotes, it showing error..what should i do to achieve this?

Re: Problem in Multiple selection in mastercalender

parimikittu — Thu, 05 Jan 2017 06:20:01 GMT

Count({"less than symbol"releaving_date={">$(=MonthStart(max(Month)))"}>} Empid). Somehow my answer is not displaying corretly "greate than symbol" with <

Re: Problem in Multiple selection in mastercalender

Thu, 05 Jan 2017 07:18:32 GMT

Here data showing correctly but as per requirement I want to show employee count one because of in may month one employee relived.when I choose multiple selection want to display current employee count, no need count of who are relieved employee's.

Re: Problem in Multiple selection in mastercalender

parimikittu — Thu, 05 Jan 2017 07:27:10 GMT

Hi Niranjan, Wat is the output when u have selected MAY,June? is it not 1 as expected?

Re: Problem in Multiple selection in mastercalender

Thu, 05 Jan 2017 07:31:26 GMT

as per requirement I want to show employee count one because of in may month one employee relived.when I choose multiple selection want to display current employee count, no need count of who are relieved employee'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

Re: Problem in Multiple selection in mastercalender

parimikittu — Thu, 05 Jan 2017 07:35:06 GMT

Hi Niranjan, i'm clear on ur requirement. Please let me know the outcome of my formula

Re: Problem in Multiple selection in mastercalender

Thu, 05 Jan 2017 07:38:21 GMT

not getting correct result

Re: Problem in Multiple selection in mastercalender

Thu, 05 Jan 2017 09:58:56 GMT

=Count (DISTINCT { $ <Year={$(=(ma:@Year)))},Month={$(=MaxString(Month))} >} Emp_ID )

This is correct answer

Re: Problem in Multiple selection in mastercalender

Thu, 05 Jan 2017 10:02:28 GMT

=Count (DISTINCT { $ <Year={$(=(max(Year)))},Month={$(=MaxString(Month))}>} Emp_ID )

This is correct answer