Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Master II
Master II

How do I create Cyclic Group in Sense

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.

5 Replies
Creator
Creator

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.

Partner
Partner

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.

Employee
Employee

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!

Master II
Master II

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?

Creator
Creator

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.