Here's a link to a document that I wrote on this topic:
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
Your post was helpful but here is my example below
LOAD * INLINE [
Year List, Quarter Year, Month Year
2011, Q1, Jan
2012, Q2, Feb
2013, Q3, Mar
2014, Q4, Apr
2015, , May
2016, , Jun
, , Jul
, , Aug
, , Sep
, , Oct
, , Nov
, , Dec
And the end result should be all these 3 fields (Year List, Quarter Year, Month Year) as Cyclic group or one single Field but also these fields should be available as single.
So Cyclic Group as 3 fields combined and also all three fields still available.
How can we achieve this, do we need to create a single dummy dimension in Inline Load which reflects these 3 fields?
There are no Cyclic groups in Sense.
Option1: Use List box extension (Attached)
or you can find more alternatives in branch.qlik.com
If your version is 2.2.4 or 3.0 & up i would suggest to take a look at this "Alternate Dimensions & Mesarues" concept. This is out of the box and don't need any custom extensions.
Hope this answer your questions.
bi-listbox_v2.zip 29.5 K
I would encourage use of Option 2 first, then Option 1. Option 2 is the Qlik Sense approach to a feature called Cyclic Groups in QlikView. This is a viable solution and addresses the desired use case requirement. I thank you and appreciate you taking time to create a solution application. This makes life so much easier to see an example and play with it (or reverse engineer). Great stuff!