topic Issue while creating a calendar for the app in QlikView

Issue while creating a calendar for the app

Tue, 28 Aug 2012 06:08:37 GMT

Hi,

I am using the following code for 'Q'&Ceil(Month(ReportedDate)/3) AS CalendarQuarter and i am getting (Q,Q1,Q2,Q3,Q4) as values. When i remove the 'Q' from the code am just getting the quarter numbers(1,2,3,4). Unable to trace out the issue.

Regards,

Srikar

Re: Issue while creating a calendar for the app

Tue, 28 Aug 2012 06:26:27 GMT

Dear,

Srikar.

try to apply where condition at the end.

Test:

Load

-----

---------

-----------

where exist(ReportedDate,ReportedDate);

i hope it will help you.

Thanks,

Mukram.

Re: Issue while creating a calendar for the app

whiteline — Tue, 28 Aug 2012 07:52:37 GMT

It seems that ReportedDate sometimes is null.

Try Ceil(if(not isnull(Month(ReportedDate)), Month(ReportedDate), 'NULL')/3) AS CalendarQuarter