Qlik Community

Qlik Sense Enterprise Documents

Documents for Qlik Sense related information.

Cyclic Group By using Filterpane

pathiqvd
Contributor III

Cyclic Group By using Filterpane

     Hi to All. I am going to Share My knowledge, How to create Cyclic Group in Qliksense. We can download lot off extensions from Qlik branch for Cyclic dimension or Cyclic Group. But I tried lot off ways to solve without extension. finally i got solution. May be this solution know to all or i don't know. But I am trying to give Solution.

Suppose we have table like this,

Load

Region,

Year,

ID,

Agent,

Country,

Sales,

State,

Make,

Model,

Premium,

..........Etc from tablename;

Step1:-

First Create one inline table in script for Cyclic Dimension Based on which fields do you want

Like:-

Cyclic_Table:

load * inline [

Cyclic_dimension

Region

Agent

Year

Make

];

Load the data and go to app overview and create chart take dimension like

Step2:-

Dimension:-

=$(=if(GetSelectedCount(Cyclic_dimension)=0,'Region',Only(Cyclic_dimension)))

Measure:-

=sum(Sales)

Step3:-

Take Cyclic_dimension field As  Filter.


And If you want change Filter Title Based on Field Name Take this exp:-

=if(GetSelectedCount(Cyclic_dimension )=0,'Region',

if(Only(Cyclic_dimension )='Region','Region',

if(Only(Cyclic_dimension )='Agent','Agent',

if(Only(Cyclic_dimension )='Year','Year',

if(Only(Cyclic_dimension )='Make','Make')))))

           This is My first Documentation,. If there any mistakes Please forgive me.

Thanks & Regards,

Lakshmipathi,



Comments
Not applicable

Nice work useful.............

Version history
Revision #:
1 of 1
Last update:
‎08-06-2017 12:42 AM
Updated by: