Qlik Community

Ask a Question

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY

Add standard date dimension fields to the built-in Qlik Compose Date Dimension

paulstevens
Partner
Partner

Add standard date dimension fields to the built-in Qlik Compose Date Dimension

Add additional standard date fields to the date dimension. These are fields commonly on date dimension tables and are used for various reporting date range calculations, but are absent from the built-in date dimension within Qlik Compose. These additional fields would be helpful to include within Qlik Compose.

Week Start Date

Week End Date

Month Start Date

Month End Date

Quarter Start Date

Quarter End Date

Quarter Description Str2   (Q1, Q2, Q3, Q4)

Year Start Date (1 January <year>)

Year End Date (31 December <year>)

IsWeekday (If Day of week is Mon, Tues, Wed, Thurs, Friday, then TRUE, else FALSE)

 

The current workaround is to create each field as an attribute in the Date dimension in the entity model and add the Expression for the attribute.

Tags (1)
1 Comment
Tzachi_Nissim
Employee
Employee

Hi Paul,

Thank you. What you describe as a workaround is actually the correct way to add things to the date dimension. We tried to put in the date dimension all the commonly used date attributes. I'll open this for community feedback. 

Regards,

Tzachi

Status changed to: Open - Collecting Feedback