Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem in Multiple selection in mastercalender

I have uploaded my problem through attachment,

if any one know could you please give explanation through expressions

Regards,

Niranjan B

19 Replies
parimikittu
Creator II
Creator II

Hi Niranjan,

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

not able to paste my answer

Not applicable
Author

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?

parimikittu
Creator II
Creator II

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

Not applicable
Author

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.

parimikittu
Creator II
Creator II

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

Not applicable
Author

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

parimikittu
Creator II
Creator II

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

Not applicable
Author

not getting correct result

Not applicable
Author

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


This is correct answer

Not applicable
Author

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


This is correct answer