Cyclic Group in QlikSense

[raju_salmon]

Hi,

Do we have cyclic group creation option in QlikSense?? or only DrilDown?

Thanks.

[reddy-s]

Hi Raju,

There is no cyclic group creation in QlikSense but that can easily be achieve through expressions in the front end.

For example:

Use this as an inline load in your script.

//Considering that you already have Year, Quarter and Month as dimensions declared by your master calendar.

[Cycle]:

load * inline [

Cgroup

Year

Quarter

month

];

Create a filter with the Cgroup field on the sheet.

Now Create  a bar chart using the following expressions:

Dimension:

pick(match(getfieldSelection(Cgroup),'Year','Quarter','Month'),[Year],[Quarter],[Month])

Measure:

Sum(Sales)

If you feel having a button or a set of toggle buttons to cycle through the dimensions, you have the leverage in QlikSense to develop an extension to fit your cause.

Thanks and Regards,

Sangram Reddy.

[ogster1974]

‌Hi raju

IF you follow this link it willshow you how to mimic a cyclical group using extensions.

Makes Sense to go round in circles

[raju_salmon]

Hi My expression is showing error. Can you see once.

Pick(match(getfieldSelection(CGroup),'DATE','CAL_WEEK','CAL_MONTH','CAL_QUARTER'),DATE,CAL_WEEK,CAL_MONTH,CAL_QUARTER)

[Cycle]:

load * inline [

CGroup

DATE

CAL_WEEK

CAL_MONTH

CAL_QUARTER

];

The below fields are available in my calender object.

DATE

CAL_WEEK

CAL_MONTH

CAL_QUARTER

[reddy-s]

Hi Raju,

Its GetFieldSelections()...I miss spelt it as well in my comment.

Thanks and Regards,

Sangram Reddy.

[raju_salmon]

Sorry Man, i too did not observe. Sorry for wrong question. Thanks for response.

If i add extension object as suggestion by ANDY... will it be any problem in QMC or at end user place? means, he need to open the app in IE, not in AJAX like that?

or there will be no difference? i have never used extension objects.

[ogster1974]

If they consuming the app via the server then no you will have loaded the extension onto the server.  if you choose to share the app with another user using desktop then they would have to make sure they also had the same extensions loaded onto their local machine.