topic urgent help needed in QlikView

urgent help needed

Mon, 08 Jul 2013 13:57:23 GMT

Plez I need urgent help to find the quaterly sales of the country. I did the following things,

Year(OrderDate)as OrderYear,

year(OrderDate)& month(OrderDate)as MonthYear,

Year(OrderDate) & Ceil(Month(OrderDate)/3) as YearQtr,

RequiredDate,

any link or website with detail of edit script will be more welcome

thank you

jpapador — Mon, 08 Jul 2013 14:09:56 GMT

'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"

Mon, 08 Jul 2013 15:18:36 GMT

Thanks you so much jpapador.Really appreciated.