topic Re: Problem with selection/view in QlikView https://community.qlik.com/t5/QlikView/Problem-with-selection-view/m-p/690322#M249960 <HTML><HEAD></HEAD><BODY><P>so thats my problem and I have no idea how to solve this.</P></BODY></HTML> Tue, 01 Jul 2014 15:13:38 GMT 2014-07-01T15:13:38Z Problem with selection/view https://community.qlik.com/t5/QlikView/Problem-with-selection-view/m-p/690318#M249956 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I want to show in the table the number of holidays per person whatever else is selected, but just the persons in the selected departments.&nbsp; So for example if department1 is selected I want miller and smith with two holidays.</P><P></P><P>Has someone an idear how I can solve this problem?</P><P></P><P>Greatings</P><P>m.sonnenschein</P></BODY></HTML> Tue, 01 Jul 2014 14:33:53 GMT https://community.qlik.com/t5/QlikView/Problem-with-selection-view/m-p/690318#M249956 2014-07-01T14:33:53Z Re: Problem with selection/view https://community.qlik.com/t5/QlikView/Problem-with-selection-view/m-p/690319#M249957 <HTML><HEAD></HEAD><BODY><P>The field Holiday contains nulls which are not included in the count. You can use any other field like date: COUNT(Date)</P></BODY></HTML> Tue, 01 Jul 2014 14:38:24 GMT https://community.qlik.com/t5/QlikView/Problem-with-selection-view/m-p/690319#M249957 Gysbert_Wassenaar 2014-07-01T14:38:24Z Re: Problem with selection/view https://community.qlik.com/t5/QlikView/Problem-with-selection-view/m-p/690320#M249958 <HTML><HEAD></HEAD><BODY><P>Marius,</P><P>Are you sure that your Holiday table should even be connected to your Work table?&nbsp; The reason only one of the holidays counts up is because nobody worked on 01.01.2014. Therefore when you select something in the Work table, it will definitely filter out that date and depending on your selection might also filter out 06.01.2014.</P></BODY></HTML> Tue, 01 Jul 2014 14:42:27 GMT https://community.qlik.com/t5/QlikView/Problem-with-selection-view/m-p/690320#M249958 Anonymous 2014-07-01T14:42:27Z Re: Problem with selection/view https://community.qlik.com/t5/QlikView/Problem-with-selection-view/m-p/690321#M249959 <HTML><HEAD></HEAD><BODY><P>Is this what you are interested in seeing?</P></BODY></HTML> Tue, 01 Jul 2014 14:46:35 GMT https://community.qlik.com/t5/QlikView/Problem-with-selection-view/m-p/690321#M249959 Greg_Williams 2014-07-01T14:46:35Z Re: Problem with selection/view https://community.qlik.com/t5/QlikView/Problem-with-selection-view/m-p/690322#M249960 <HTML><HEAD></HEAD><BODY><P>so thats my problem and I have no idea how to solve this.</P></BODY></HTML> Tue, 01 Jul 2014 15:13:38 GMT https://community.qlik.com/t5/QlikView/Problem-with-selection-view/m-p/690322#M249960 2014-07-01T15:13:38Z