Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
expression =count($(vGroup))
where vGroup, defined in an input box, is (remember 😃
vGroup ='[' & GetCurrentField("your cycle group") & ']'
expression =count($(vGroup))
where vGroup, defined in an input box, is (remember 😃
vGroup ='[' & GetCurrentField("your cycle group") & ']'
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.
Thank You Brother, i got the first part. would please give me more information about how to create that input box?
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