Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

quater - date

Hello,

I am trying to build a sales report,

I want to show the sales based on the first Quarter, second quarter and esc,

I have a date field how can I preform it?

1 Solution

Accepted Solutions
Highlighted

Re: quater - date

With a extra parenthesis at the end:

'Quater' &'- '& Ceil(Month(INV_IVDATE)/3)

View solution in original post

6 Replies
Highlighted
Master III
Master III

Re: quater - date

I suggest adding a Quarter field to your data model:

'Quarter ' & ceil(month(someDate)/3) as Quarter,

Don't allow Perfection to be the enemy of Good Enough.
May you live in interesting times!
Highlighted
Not applicable

Re: quater - date

YOU MEAN THAT IF MY FIELD IS INV_IVDATE

I SHOULD wright it like this:

'Quater' &'- '&ceil(month(INV_IVDATE)/3 as quater ?

Highlighted

Re: quater - date

With a extra parenthesis at the end:

'Quater' &'- '& Ceil(Month(INV_IVDATE)/3)

View solution in original post

Highlighted
Master III
Master III

Re: quater - date

Yes; add that as field in the table during your reload .

Don't allow Perfection to be the enemy of Good Enough.
May you live in interesting times!
Highlighted
Master III
Master III

Re: quater - date

Silly me; I overlooked that one . Sharp one, Sunny!

Don't allow Perfection to be the enemy of Good Enough.
May you live in interesting times!
Highlighted

Re: quater - date

No problemo