Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Pomna
Creator III
Creator III

Master Calendar

Experts,

I have a master calendar that works fine but am having issues getting 'YearQuarter'.  Any suggestions how to achieve that would be appreciated. Thank you

3 Replies
tresesco
MVP
MVP

Could you explain with an example?

Pomna
Creator III
Creator III
Author

The below is a sample calendar (Not Mine). It has year, quarter, month , day and week. I need the calendar to show YearQuarter.  For example

2021 Q1

2021 Q2

 

CalendarMaster:

LOAD

    Date(InvoiceDate) AS InvoiceDate,

    Year(InvoiceDate) AS Year,

    'Q' & Ceil(Month(InvoiceDate) / 3) AS Quarter,    

    Month(InvoiceDate) As Month,

    Day(InvoiceDate) As Day,

    Week(InvoiceDate) As Week;

Load Date(MinDate + IterNo() -1 ) AS InvoiceDate While (MinDate + IterNo() - 1) <= Num(MaxDate);

Load

    Min(InvoiceDate) AS MinDate,

    Max(InvoiceDate) AS MaxDate

RESIDENT Invoice;

tresesco
MVP
MVP

Is it not just concatenation?  Like:

Year & ' ' & Quarter   AS   YearQuarter