Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
steve1982
New Contributor II

Create a Dimension Group

Dear All,

I has a dimension which is fiscal week. The fiscal week will update on daily basic. I want to group the week in the sequence of 4-4-5 into month, which cover total of 12 months. How this can be done in load script?

Below the example which this week is 201920, I need the Month grouping dimension.

Fiscal WeekMonth
2019201 Month
2019191 Month
2019181 Month
2019171 Month
2019162 Month
2019152 Month
2019142 Month
2019132 Month
2019123 Month
2019113 Month
2019103 Month
2019093 Month
2019083 Month
2019074 Month
2019064 Month
2019054 Month
2019044 Month
2019035 Month
2019025 Month
2019015 Month
2019005 Month
2018996 Month
2018986 Month
2018976 Month
2018966 Month
2018956 Month
2018947 Month
2018937 Month
2018927 Month
2018917 Month
2018908 Month
2018898 Month
2018888 Month
2018878 Month
2018869 Month
2018859 Month
2018849 Month
2018839 Month
2018829 Month
20188110 Month
20188010 Month
20187910 Month
20187810 Month
20187711 Month
20187611 Month
20187511 Month
20187411 Month
20187312 Month
20187212 Month
20187112 Month
20187012 Month
20186912 Month

Thanks in advance

Steve

1 Reply
MVP & Luminary
MVP & Luminary

Re: Create a Dimension Group

I think I would use for this an extra 4-4-5 calendar parallel to your fiscal calendar (and probably a "normal" one). How it might be created, see: Non-Gregorian-calendars.

- Marcus