Discussion Board for collaboration on QlikView Scripting.
Plez I need urgent help to find the quaterly sales of the country. I did the following things,
year(OrderDate)& month(OrderDate)as MonthYear,
Year(OrderDate) & Ceil(Month(OrderDate)/3) as YearQtr,
any link or website with detail of edit script will be more welcome
Go to Solution.
'Q' & Ceil(Month(Date)/3) as Quarter,
Dual('Q' & Ceil(Month(Date)/3) & '-' & Year(Date), Year(Date) & Ceil(Month(Date)/3)) as QtrYear,
Date(MonthStart(Date), 'MMMYYYY') as MonthYear
Try that. Replace "Date" with "OrderDate"
Thanks you so much jpapador.Really appreciated.