Extra value in Quarter data - Q

[qlikviewwizard]

Hi All,

I am getting Extra value in Quarter data - Q.

Using the below formula in script.

'Q'&ceil(month(date(HireDate))/3) as Quarter.

I am using SET DateFormat='DD-MMM-YYYY'; in script.

Please help me.

[qlikmsg4u]

Hi,

I think the dates with Null value or Missing dates creates this problem.

[arulsettu]

try like this

dual('Q'&ceil(month(date(HireDate))/3),ceil(month(date(HireDate))/3)) as Quarter

[Gysbert_Wassenaar · Accepted solution]

Try: if(IsNum(HireDate), 'Q'&ceil(month(date(HireDate))/3)) as Quarter.

[sunilkumarqv]

try this

IF(Len(HireDate)>0,'Q'&ceil(month(date(HireDate))/3)) as Quarter.

[qlikviewwizard]

Thank you gwassenaarsunilkumarqv,arulsettu

[jagan]

Hi,

If you have missing dates in the field then you will get like this, check why you are getting empty values in Date column, if the date value is mandatory then this will be the issue, also those records will not be available for selection.

Cross check the missing dates, if it is not a concern then you can use

If(Len(Trim(HireDate))>0,'Q' & Ceil(Month(HireDate)/3)) as Quarter

Hope this helps you.

Regards,

Jagan.