Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
mambi
Creator III
Creator III

Dynamic cyclic group

Hi everyone,

as you can see in the image below , i want to use %dimensions as a cyclic group. but my problems is :

for exemple if i select 'Category' in the  %dimensions listbox and the cyclic group is on 'Category' => the graph will display 100 % which make no sense.

so i want to remove dynamically from the cyclic group the item selected on the %dimensions list box.

any idea ?.

img2.png

15 Replies
mambi
Creator III
Creator III
Author

Sorry, but here what i should get : for exemple if i select category in the %dimensions:

1.png

2.png

and in this case : the cyclic group shouldn't contain the Category in the list of choices.

avinashelite

Check the attachment for the solution

mambi
Creator III
Creator III
Author

what i want to do is :

- when Country is selected in the listbox the cyclic group should contain only : Product and Category

- when Category is selected in the listbox the cyclic group should contain only : Product and Country

- when Product is selected in the listbox the cyclic group should contain only  : Category and Country

- when Country and Category are selected in the listbox then the cyclic group should contain only Product

- when Country and Product are selected in the listbox then the cyclic group should contain only Category

- when Product and Category are selected in the listbox then the cyclic group should contain only Country.

and all this dynamically because the number of items in the listbox can increase over time.

ramoncova06
Partner - Specialist III
Partner - Specialist III

and what if nothing is selected in the listbox, are you expecting to see all three ?

smirkinaa
Contributor III
Contributor III

Hi, it is not beautiful solution, but it is . You may use several cyclic dimensions. Then, show or hide depend on selections in appropriate field.

mambi
Creator III
Creator III
Author

i use a conditional display : GetSelectedCount(%dimensions)>0