topic Re: Cyclic Group count script in QlikView

Cyclic Group count script

arixooo123 — Fri, 27 Jun 2014 12:11:18 GMT

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

Re: Cyclic Group count script

maxgro — Fri, 27 Jun 2014 12:27:54 GMT

expression =count($(vGroup))

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

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

Re: Cyclic Group count script

sudeepkm — Fri, 27 Jun 2014 12:30:41 GMT

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.

Re: Cyclic Group count script

arixooo123 — Fri, 27 Jun 2014 12:31:58 GMT

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

Re: Cyclic Group count script

maxgro — Fri, 27 Jun 2014 12:58:04 GMT

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