6 Replies Latest reply: Jan 7, 2016 4:24 AM by Andy Weir RSS

    Cyclic Group in QlikSense

    Raju Salmon

      Hi,

       

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

       

      Thanks.

        • Re: Cyclic Group in QlikSense
          Sangram Reddy

          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.

          • Re: Cyclic Group in QlikSense
            Andy Weir

            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