Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Do we have cyclic group creation option in QlikSense?? or only DrilDown?
Thanks.
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.
Hi raju
IF you follow this link it willshow you how to mimic a cyclical group using extensions.
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
Hi Raju,
Its GetFieldSelections()...I miss spelt it as well in my comment.
Thanks and Regards,
Sangram Reddy.
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.
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.