logo-MindMajix
k
kavya A

Posted on 23rd June 2024|341 views

0
votes

What Is The Procedure In Qlik Sense To Create A Cyclic Group?

Please explain about the cyclic group. please explain.

1 answers
Answers
P
Aryan Sharma

Posted on 23rd June 2024| views

Following these steps in basic settings that will be done for every solution. 

Let's take a sample Table structure as Branch, State and Location. 

Next, the Is Sample Name and Branch and State Location are:

  • Sample1 next Branch1 Then State1 and Location(USA)
  • Sample2 next Branch2  Then State2 and Location(India)

 

Cycle drill is created containing

  • Branch
  • State
  • Location 

 

Load info and create in order load

Drill_below:

load * inline

[

SampleName, SampleName_Label

Branch, Branch Name

State, State Name

Location, Location Name

];

 

Once the data has been loaded there are two ways to look at Drill_below inFilter, these will be available in the Qlik Sense app. This will not be able to receive the default value, and due to this multiple selections will be enabled. If the first load drill is selected and visible then the client wouldn't worry about it. 

 

Now as the drill sections are ready we need to link charts to these drills. 

When we have a particular drill that needs to be connected to the drill, we have two ways which go as follows:

  • Use if condition
  • Use Pick Match

 

If the data is large its lags for the charts to load/reload, use the below-mentioned way:

 

Function capabilities, in Size, Create dimension Looks like

 

$(=if(GetSelectedCount(SampleName_Label)=0,’Location’,only(SampleName)))

Measures are created as per the requirement, which gives a cyclic group. 

 

Write your answer

STILL GOT QUERIES?

Get a Live FREE Demo

  • Explore the trending and niche courses and learning maps
  • Learn about tuition fee, payment plans, and scholarships
  • Get access to webinars and self-paced learning videos
Name
Course *
Email *
Phone Number