topic Re: quater - date in QlikView

quater - date

Tue, 10 Nov 2015 12:27:55 GMT

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?

oknotsen — Tue, 10 Nov 2015 12:38:04 GMT

I suggest adding a Quarter field to your data model:

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

Tue, 10 Nov 2015 12:43:32 GMT

YOU MEAN THAT IF MY FIELD IS INV_IVDATE

I SHOULD wright it like this:

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

sunny_talwar — Tue, 10 Nov 2015 14:59:29 GMT

With a extra parenthesis at the end:

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

oknotsen — Tue, 10 Nov 2015 14:59:41 GMT

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

oknotsen — Tue, 10 Nov 2015 15:33:07 GMT

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

sunny_talwar — Tue, 10 Nov 2015 15:34:09 GMT

No problemo