Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Cyclic Group count script

Hello my qlikview friends!

i Have a cyclic group on my bar chart dimension, I like to count the selected item rows to show it on the chart.

what should i type in the expression window?

to be better understood, let say my cyclic group consist of 12 different indices, when user select one of them chart must show the count of just that item.

when i select one of the indices as dimension, it's easy. i just type count(the dimension index) . but now that they are in a cyclic group i don't know how to write the expression.

Thank you Guys in advance

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

expression          =count($(vGroup))

where vGroup, defined in an input box, is (remember 😃

vGroup          ='[' & GetCurrentField("your cycle group") & ']'

View solution in original post

4 Replies
Highlighted
MVP
MVP

expression          =count($(vGroup))

where vGroup, defined in an input box, is (remember 😃

vGroup          ='[' & GetCurrentField("your cycle group") & ']'

View solution in original post

Highlighted
Specialist III
Specialist III

if your cyclic group name is ABC then you can try like below.

count($(=GetCurrentField(ABC)))

This will give you the count of field values in that field selected in the cyclic group.

Highlighted
Creator III
Creator III

Thank You Brother, i got the first part. would please give me more information about how to create that input box?

Highlighted
MVP
MVP

this is just one of the way of create variables (you can also use ctrl + alt + v  or in menu settings, variable overview )

in an empty space of your sheet right click, new sheet object, input box