Discussion Board for collaboration on QlikView Scripting.
Go to Solution.
'Q' & Ceil(Month(AddMonths(date_calendrier, -2))/3) AS Trimestre_Calendrier,
QuarterName (AddMonths(date_calendrier, -2)) as Trimestre_Année_calendrier,
QuarterStart (AddMonths(date_calendrier, -2)) as Début_Trimestre_Calendrier,
You can try using inline like
Load * Inline [
thank you Ducati.
it runs well now
No thanks. Glad it works. Could you please mark the answer as the correct one?
I would like ti mark the answer, but I don't know why, the button has disapear of the screen... so I can't do that!
You could also try this way - adding below to script & add / delete the months you want in that quarter;
IF (MIXMATCH(LEFT(MONTHNAME(BOOKED_DATE),3),'Jan','Feb','Mar')>0,'Q1') AS QTR_BOOKED