topic Re: Master Calendar Issue - how to include quarter-year in QlikView

Master Calendar Issue - how to include quarter-year

Mon, 18 Jan 2016 18:48:06 GMT

Hello to all,

I want to develop a quarter rolling chart.

I already have a QuarterID field in my master calendar, which gives me a way to perform the set analysis for the chart.

Below, my master calendar:

The problem is that I don't have a field to use such as a 'Quarter-Year' to use as my dimension for the chart.

Using the field QuarterID as a dimension, I have the information I need, but not in a 'friendly user way'.

I need a field that says 'Q4-2015' in the place of '12' in the chart above.

How can I create a field like this in my master calendar?

Thanks for your support!!

sunny_talwar — Mon, 18 Jan 2016 19:01:11 GMT

Create it like this may be:

Dual('Q' & Ceil(Month(Temp_Date)/3) & '-' & Year(Temp_Date), QuarterStart(Temp_Date)) as QuarterYear

Gysbert_Wassenaar — Mon, 18 Jan 2016 19:02:58 GMT

Or create your QuarterID this way: Dual(Quarter & '-' & Year, Autonumber(Quarter & Year,'QuarterID')) as QuarterID

Wed, 20 Jan 2016 18:04:41 GMT

Sunny,

Thanks for the support. I used the expression below to solve my issue, based on your and Gysbert answer.

Year(Temp_Date) & '-' & 'Q' & Ceil(Month(Temp_Date)/3)

as [Quarter - Year]

Kind regards,

Marco

Wed, 20 Jan 2016 18:05:03 GMT

Gysbert,

Thanks for the support. I used the expression below to solve my issue, based on your and Sunny answer.

Year(Temp_Date) & '-' & 'Q' & Ceil(Month(Temp_Date)/3)

as [Quarter - Year]

Kind regards,

Marco