Re: Cyclic group count - Qlik Community

Anonymous · ‎2016-12-13

Dear All,

I have used one cyclic group called "ABC" in pivot table and it has 10+ dimension like Country , State , City etc... .

I want whenever user select any dimension then dimension count will be seen as Label .

Exp: If user select country say India in ABC group and change to city then it should display count of city which is present in India in label.

Thanks

sushil353 · ‎2016-12-13

Hi,

Try using GetCurrentfield(ABC)

HTH

Anonymous · ‎2016-12-13

I have written like this

=if(GetCurrentField($(ABC)),Count(($(ABC))))

but it is not working

Anonymous · ‎2016-12-13

Any suggestion???

Anil_Babu_Samineni · ‎2016-12-13

Does ABC is the variable? If so, Can you elapse that variable expression to understand?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2016-12-13

it is ABC is cyclic group name

Anil_Babu_Samineni · ‎2016-12-13

This simple Field, You meant to say. Correct me if i am wrong.

And, Can you tell me one thing Why you are using $ Symbol here

Perhaps this,

=Count({$<ABC = {"$(=GetCurrentField(ABC))"}>} ABC)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2016-12-13

count is showing but when i am take another dimension then count not showing

Anonymous · ‎2016-12-13

in this attachment

If i select state GOA from cyclic group and then turn into Brand then it should show me Brand count as lable.

MK9885 · ‎2016-12-13

PFA.

You can simply use

= 'Count of Brand'& chr(10)& count(Brand) >>>>>In your Cyclic group Label.

Correct me if I'm wrong. I think you only looking for Counts of Brand