Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

arixooo123
Contributor

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

Tags (3)
1 Solution

Accepted Solutions
MVP
MVP

Re: Cyclic Group count script

expression          =count($(vGroup))

where vGroup, defined in an input box, is (remember =)

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

4 Replies
MVP
MVP

Re: Cyclic Group count script

expression          =count($(vGroup))

where vGroup, defined in an input box, is (remember =)

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

sudeepkm
Valued Contributor III

Re: Cyclic Group count script

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.

arixooo123
Contributor

Re: Cyclic Group count script

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

MVP
MVP

Re: Cyclic Group count script

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

Community Browser