topic Quarter in QlikView

Quarter

fanninam — Sat, 16 Nov 2024 01:18:54 GMT

I am trying to create a field for Quarter. I only have a field for Year and a field for Month. There is no date field. Only a field for Year and a field for Month. In this scenario, how can I create a field for Quarter?

Re: Quarter

sunny_talwar — Mon, 10 Feb 2020 18:27:53 GMT

If month is in number format (like 1, 2, 3 etc)... try this

'Q' & Ceil(Month/3) as Quarter 'Q' & Ceil(Month/3) & '-' & Year as QuarterYear

But if Month is text (like Jan, Feb, Mar etc)... try this

'Q' & Ceil(Month(Date#(Month, 'MMM'))/3) as Quarter 'Q' & Ceil(Month(Date#(Month, 'MMM'))/3) & '-' & Year as QuarterYear

Re: Quarter

fanninam — Mon, 10 Feb 2020 19:00:25 GMT

Thank you Sunny!