topic Re: Fetching Not entered values in QlikView

Fetching Not entered values

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

I have a data like below table: with the master calendars

If I select the

Monday --> EmpId 1 and 3 will be get.

Tuesday --> EmpId 2 and 3 will be get and so on.............

But I need

On selecting

Monday --> Entered EmpId count=2 and not entered EmpId count=3

Tuesday --> Entered EmpId count=2 and not entered EmpId count=3 and so on...............

Any one can help me in this.......

I cannot attach the sample file along with it. Sorry for the inconvenience.

Regards

Yoganantha Prakash G P

prieper — Wed, 03 May 2017 14:37:54 GMT

This depends your datamodel,

see the attached with correct calculation

Peter

johnca — Wed, 03 May 2017 15:01:40 GMT

If your data model is truly a pivot table as presented use the CrossTable function. It will flatten the table out to what Peter suggested above.

temp:

CrossTable(Day,Name,2)

Load * Inline [EmpId, Name, Mon, Tue, Wed, Thu, Fri

1,A,y,,y,y,

2,B,,y,,,y

3,C,y,y,y,y,y

4,D,,,,,

5,E,,,y,y,

];

HTH,

John