topic Re: Extra value in Quarter data - Q in QlikView

Extra value in Quarter data - Q

qlikviewwizard — Fri, 20 Nov 2020 18:02:30 GMT

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.

Re: Extra value in Quarter data - Q

qlikmsg4u — Mon, 15 Jun 2015 06:39:34 GMT

Hi,

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

Re: Extra value in Quarter data - Q

arulsettu — Mon, 15 Jun 2015 06:39:56 GMT

try like this

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

Re: Extra value in Quarter data - Q

Gysbert_Wassenaar — Mon, 15 Jun 2015 06:41:29 GMT

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

Re: Extra value in Quarter data - Q

sunilkumarqv — Mon, 15 Jun 2015 07:36:00 GMT

try this

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

Re: Extra value in Quarter data - Q

qlikviewwizard — Mon, 15 Jun 2015 07:51:44 GMT

Thank you gwassenaarsunilkumarqv,arulsettu

Re: Extra value in Quarter data - Q

jagan — Mon, 15 Jun 2015 08:03:07 GMT

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.