topic Re: Cyclic group count in QlikView

Cyclic group count

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Cyclic group count

sushil353 — Tue, 13 Dec 2016 06:21:09 GMT

Hi,

Try using GetCurrentfield(ABC)

HTH

Re: Cyclic group count

Anonymous — Tue, 13 Dec 2016 06:49:10 GMT

I have written like this

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

but it is not working

Re: Cyclic group count

Anonymous — Tue, 13 Dec 2016 07:09:11 GMT

Any suggestion???

Re: Cyclic group count

Anil_Babu_Samineni — Tue, 13 Dec 2016 07:11:18 GMT

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

Re: Cyclic group count

Anonymous — Tue, 13 Dec 2016 07:22:56 GMT

it is ABC is cyclic group name

Re: Cyclic group count

Anil_Babu_Samineni — Tue, 13 Dec 2016 08:13:45 GMT

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)

Re: Cyclic group count

Anonymous — Tue, 13 Dec 2016 09:29:33 GMT

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

Re: Cyclic group count

Anonymous — Tue, 13 Dec 2016 10:15:26 GMT

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.

Re: Cyclic group count

MK9885 — Tue, 13 Dec 2016 13:10:20 GMT

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

Re: Cyclic group count

sunny_talwar — Tue, 13 Dec 2016 15:11:10 GMT

You can try this:

='Count -> ' & Count(DISTINCT $(='['&GetCurrentField([New Group]) & ']'))

Re: Cyclic group count

Anonymous — Wed, 14 Dec 2016 05:15:24 GMT

@sunny,

I need Dimension label also means when i do cyclic group as brand then it should display Brand > Count > 14 as Label.

Thanks

Re: Cyclic group count

Anonymous — Wed, 14 Dec 2016 05:35:43 GMT

Hi Sunny,

It will showing me all dimension count

I have four charts Zone wise if I select one division in West Zone chart and after i do cyclic to state / product or etc dimension then it is showing me all count

PFA.

Re: Cyclic group count

Anonymous — Wed, 14 Dec 2016 07:07:01 GMT

Any advice??

Re: Cyclic group count

sunny_talwar — Wed, 14 Dec 2016 09:05:25 GMT

Any advice on what my friend? I think I missed the question in your previous post?