topic Re: Count Issues on particular month in QlikView

Count Issues on particular month

Wed, 21 Aug 2013 10:22:00 GMT

hi community i m facing the problem but can't get success.

i appreciate for any kind of help from your side m using personal edition

I have two table.

Table1:

EmpCode	Date
278	5/1/2013
278	5/2/2013
278	5/3/2013
278	5/4/2013
278	5/5/2013
278	5/6/2013
278	5/7/2013
278	5/8/2013
278	5/9/2013
278	5/10/2013
278	5/11/2013
278	5/12/2013
278	5/13/2013
278	5/14/2013
278	5/15/2013
278	5/16/2013
278	5/17/2013
278	5/18/2013
278	5/19/2013
278	5/20/2013
278	5/21/2013
278	5/22/2013
278	5/23/2013
278	5/24/2013
278	5/25/2013
278	5/26/2013
278	5/27/2013
278	5/28/2013
278	5/29/2013
278	5/30/2013
278	5/31/2013
278	6/1/2013
278	6/2/2013
278	6/3/2013
278	6/4/2013
278	6/5/2013
278	6/6/2013
278	6/7/2013
278	6/8/2013
278	6/9/2013
278	6/10/2013
278	6/11/2013
278	6/12/2013
278	6/13/2013
278	6/14/2013
278	6/15/2013
278	6/16/2013
278	6/17/2013
278	6/18/2013
278	6/19/2013
278	6/20/2013
278	6/21/2013
278	6/22/2013
278	6/23/2013
278	6/24/2013
278	6/25/2013
278	6/26/2013
278	6/27/2013
278	6/28/2013
278	6/29/2013
278	6/30/2013
278	7/1/2013
278	7/2/2013
278	7/3/2013
278	7/4/2013
278	7/5/2013
278	7/6/2013
278	7/7/2013
278	7/8/2013
278	7/9/2013
278	7/10/2013
278	7/11/2013
278	7/12/2013
278	7/13/2013
278	7/14/2013
278	7/15/2013
278	7/16/2013
278	7/17/2013
278	7/18/2013
278	7/19/2013
278	7/20/2013
278	7/21/2013
278	7/22/2013
278	7/23/2013
278	7/24/2013
278	7/25/2013
278	7/26/2013
278	7/27/2013
278	7/28/2013
278	7/29/2013
278	7/30/2013
278	7/31/2013

Table2:

EmpCode	StartDate	EndDate	No. Of Absent
278	5/30/2013	5/30/2013	1
278	6/20/2013	6/20/2013	1
278	6/29/2013	7/2/2013	4

Now i want output like below when i select the particular month in calender.

Output
EmpCode	No . Of Absent
278	1	when user select May In Calendar
278	3	when user select june In Calendar
278	2	when user select july In Calendar

my calender like this

year

2013

Month

May

June

July

Thanks & Regards

Re: Count Issues on particular month

swuehl — Wed, 21 Aug 2013 10:28:41 GMT

You can transform your Table2 to a table that contains a record per absent date, like discribed in this blog post.

Then just link this table to a calendar, use Month as dimension and count(AbsentDate) as expression.

Hope this helps,

Stefan

Re: Count Issues on particular month

Wed, 21 Aug 2013 11:13:32 GMT

sir

when i select month june then i want output in pivot like-

EmpCode No. Of Absent

278 3

similarly

when i select month july then i want output in pivot like

EmpCode No. Of Absent

278 2

Thanks & Regards

Re: Count Issues on particular month

Thu, 22 Aug 2013 06:56:38 GMT

please help me urgently to solve this problem.

Re: Re: Count Issues on particular month

Thu, 22 Aug 2013 08:27:12 GMT

This is basically using the same logic to the blog and idea suggested by swuehl.

Re: Count Issues on particular month

Thu, 22 Aug 2013 10:34:59 GMT

Thanks a lot sir swuehl

Regards

vishwaranjan

Re: Count Issues on particular month

Thu, 22 Aug 2013 10:40:11 GMT

Thanks a lot sir swuehl
swuehl

Regards

vishwaranjan