How do I create Cyclic Group in Sense

[MK9885]

I wanted to create a cyclic group in Sense for the following fields.

Field1

Field2

Field3

The end result should be Field4 as one single field which has all 3 fields and their data as well.

I tried doing Inline but I might not be doing it correctly.

I want to add this cyclic grp as a dimension as I cannot add 3 dimensions for many of the charts...

As an example for year//quarter/month as one field.

Thanks.

[harvinderjohal]

Here's a link to a document that I wrote on this topic:

Simulating Alternate Dimensions and Measures across multiple visualization objects

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.

[phaneendra_kunc]

There are no Cyclic groups in Sense.

Option1:  Use List box extension (Attached)

or you can find more alternatives in branch.qlik.com

Option2: (preferred)

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.

Qlik Sense 3.0 - Alternate Dimensions & Measures Improved

Hope this answer your questions.

[Greg_Williams]

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!

[MK9885]

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?

[suresh_qv50]

1. You can get cyclic groups in qliksense by using CVL DimensionList Extension from qlik branch. its very easy approach, Its very optimised one.

2. by using Variable and $sign Expression you will achieve the same.