This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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
Could you explain with an example?
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
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);
Min(InvoiceDate) AS MinDate,
Max(InvoiceDate) AS MaxDate
Is it not just concatenation? Like:
Year & ' ' & Quarter AS YearQuarter