Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Master Calendar Issue - how to include quarter-year

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:

Quarter-Year_Master Calendar_Community Question-1.PNG

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

Quarter-Year_Master Calendar_Community Question-2.PNG

Quarter-Year_Master Calendar_Community Question-3.PNG

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!!

4 Replies

Re: Master Calendar Issue - how to include quarter-year

Create it like this may be:

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

Re: Master Calendar Issue - how to include quarter-year

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


talk is cheap, supply exceeds demand
Not applicable

Re: Master Calendar Issue - how to include quarter-year

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

Not applicable

Re: Master Calendar Issue - how to include quarter-year

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

Community Browser