Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master II
Master II

Extra value in Quarter data - Q

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.

1.JPG

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

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


talk is cheap, supply exceeds demand

View solution in original post

6 Replies
Highlighted
Specialist
Specialist

Hi,

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

Highlighted
Master III
Master III

try like this

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

Highlighted
MVP & Luminary
MVP & Luminary

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


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Specialist II
Specialist II

try this

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

Highlighted
Master II
Master II

Highlighted
MVP & Luminary
MVP & Luminary

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.