topic 5 Quarters? in QlikView

5 Quarters?

pgalvezt — Fri, 26 Aug 2011 15:46:21 GMT

Hi everyone,

I have a query where I call some date and I' ve created the normal calendar, but when I put 'Q' & Ceil(Month(Date_S)/3) AS Quarter.

The result is:

I don´t know why appear the Q in the dashboard. it would be Q1 to Q4 right?

Thanks.

Re: 5 Quarters?

swuehl — Fri, 26 Aug 2011 15:55:35 GMT

I would assume, that ceil(month(Date_S)/3) returns no result (NULL) for some record. Are you sure you have data for all records? If you are not sure, you might want to check the record with isnull before building your Quarter string.

edited:

if(isnull(Date_S)=0, YOUREXPRESSION ) as Quarter,

edited by swuehl

5 Quarters?

SunilChauhan — Fri, 26 Aug 2011 16:02:14 GMT

if(Ceil(Month(Date_S)/3)<>'Q',Ceil(Month(Date_S)/3))

5 Quarters?

pgalvezt — Fri, 26 Aug 2011 17:46:28 GMT

Gave me the same result. But I eliminated the 'Q' and my final table was 1,2,3,4.

Thanks Guys.