Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Problem with selection/view

Hi,

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.  So for example if department1 is selected I want miller and smith with two holidays.

Has someone an idear how I can solve this problem?

Greatings

m.sonnenschein

4 Replies
MVP & Luminary
MVP & Luminary

Re: Problem with selection/view

The field Holiday contains nulls which are not included in the count. You can use any other field like date: COUNT(Date)


talk is cheap, supply exceeds demand
aaroncouran
Contributor III

Re: Problem with selection/view

Marius,

Are you sure that your Holiday table should even be connected to your Work table?  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.

Employee
Employee

Re: Problem with selection/view

Is this what you are interested in seeing?

Not applicable

Re: Problem with selection/view

so thats my problem and I have no idea how to solve this.