topic Quarter Generation Problem in QlikView

Quarter Generation Problem

its_anandrjs — Mon, 25 Jul 2011 14:10:39 GMT

Hi All,

I have problem when i generate Quarter at load wit this syntax:-'Q'&CEIL(MONTH(DATE([Evaluation Date]))/3) as Quarter. it creates three quarters like

Q,Q1,Q2,Q3,Q4 but here Q is unnecesary please tell me how to remove it from Quarter list..

Anand

Regrds

danielrozental — Mon, 25 Jul 2011 14:33:53 GMT

you probably have null values in Evaluation Date field.

Try avoiding them like this if(not isnull([Evaluation Date]),'Q'&CEIL(MONTH(DATE([Evaluation Date]))/3)) as Quarter

Mon, 25 Jul 2011 14:35:09 GMT

Hi

Maybe the 'Q' value is being concatenated with a null date field.

Try:

IF(ISNULL([Evaluation Date]) = 0, 'Q' & CEIL(MONTH(DATE([Evaluation Date]))/3) ) as Quarter