topic Re: Calender Issue in QlikView

Calender Issue

Mon, 12 Aug 2013 11:09:22 GMT

Hi,

I am facing one issue which are explain in detail:

Step1: I have three seperate Calender all three calender link with Fact table Date field.

Example: Calender date (Link_date)

Fact Date: Registration_date, Closed_date and Purchse_date.

Step 2: I have created seperete Calender1 and pass field as variable.

Step 3: Expression like this:

count(DISTINCT {<[REGISTRATION DATE]={">=$(monthStartDate) <=$(monthEndDate)"}>} CALL_ID)

monthStartDate:

date(MonthStart(AddMonths(date(max([Link Date])),0)),'DD-MM-YYYY')

monthEndDate:

=date(MonthEnd(AddMonths(date(max([Link Date])),0)),'DD-MM-YYYY')

Problem : when I select [Fiscal month Year] of seperate Calender1 this is not working.

Please help on this.

Regards

Ravi Gupta

Re: Calender Issue

Anonymous — Mon, 12 Aug 2013 11:39:35 GMT

Hi Ravi

Is Calendar1 linked with the fact table?

Could you please upload the tables viewer snapshot?

Regards

MultiView

Re: Calender Issue

Mon, 12 Aug 2013 11:43:08 GMT

Re: Calender Issue

er_mohit — Mon, 12 Aug 2013 11:44:47 GMT

have you tried like this way for this field

count(DISTINCT {<[REGISTRATION DATE]={">=$(monthStartDate) <=$(monthEndDate)"},[Fiscal month Year]=>}CALL_ID)

Re: Calender Issue

Mon, 12 Aug 2013 11:48:23 GMT

Hi,

Please Find out image.

Common Calender: ( Registration_Date, Closing_date, Purchase_date) as link Date

fact date field: Registration_Date, Closing_date, Purchase_date

Seperate Calender: Calender1 and field: [link date]

Expression: count(DISTINCT {<[REGISTRATION DATE]={">=$(monthStartDate) <=$(monthEndDate)"}>} CALL_ID)

monthStartDate: date(MonthStart(AddMonths(date(max([Link Date])),0)),'DD-MM-YYYY')

monthEndDate: date(MonthEnd(AddMonths(date(max([Link Date])),0)),'DD-MM-YYYY')

Pass [link date] as input field and I want to use seperate calender.

Please help.

Regards

Ravi Gupta

Re: Calender Issue

Mon, 12 Aug 2013 12:01:31 GMT

Hi,

When I try show data but data shown wrong.

count(DISTINCT {< [Fiscal MonthYear]=, [REGISTRATION DATE]={">=$(vMinDate) <=$(vMaxDate)"}>} CALL_ID)

Please check image file.

where output repaering value.

regards

Ravi

Re: Calender Issue

Mon, 12 Aug 2013 12:05:02 GMT

Hi ,

Please find output

Total	13	2	15%
Jan-2010	13	2	15%
Feb-2010	13	2	15%
Mar-2010	13	2	15%
Apr-2010	13	2	15%
May-2010	13	2	15%
Jun-2010	13	2	15%
Jul-2010	13	2	15%
Aug-2010	13	2	15%
Sep-2010	13	2	15%
Oct-2010	13	2	15%
Nov-2010	13	2	15%
Dec-2010	13	2	15%
Jan-2011	13	2	15%
Feb-2011	13	2	15%
Mar-2011	13	2	15%
Apr-2011	13	2	15%
May-2011	13	2	15%
Jun-2011	13	2	15%
Jul-2011	13	2	15%
Aug-2011	13	2	15%
Sep-2011	13	2	15%
Oct-2011	13	2	15%
Nov-2011	13	2	15%
Dec-2011	13	2	15%
Jan-2012	13	2	15%
Feb-2012	13	2	15%
Mar-2012	13	2	15%
Apr-2012	13	2	15%
May-2012	13	2	15%
Jun-2012	13	2	15%
Jul-2012	13	2	15%
Aug-2012	13	2	15%
Sep-2012	13	2	15%
Oct-2012	13	2	15%
Nov-2012	13	2	15%
Dec-2012	13	2	15%
Jan-2013	13	2	15%
Feb-2013	13	2	15%
Mar-2013	13	2	15%
Apr-2013	13	2	15%
May-2013	13	2	15%
Jun-2013	13	2	15%
Jul-2013	13	2	15%

Re: Calender Issue

Mon, 12 Aug 2013 12:33:37 GMT

Hi Mohit and Multiview,

I am waiting for your reply.

Regards

Ravi Gupta