Discussion Board for collaboration on QlikView Scripting.
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?
With a extra parenthesis at the end:
'Quater' &'- '& Ceil(Month(INV_IVDATE)/3)
View solution in original post
I suggest adding a Quarter field to your data model:
'Quarter ' & ceil(month(someDate)/3) as Quarter,
YOU MEAN THAT IF MY FIELD IS INV_IVDATE
I SHOULD wright it like this:
'Quater' &'- '&ceil(month(INV_IVDATE)/3 as quater ?
Yes; add that as field in the table during your reload .
Silly me; I overlooked that one . Sharp one, Sunny!