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,