Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
vijayptcs
Creator II
Creator II

Cyclic group count

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

14 Replies
sushil353
Master II
Master II

Hi,

Try using GetCurrentfield(ABC)

HTH

vijayptcs
Creator II
Creator II
Author

I have written like this

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

but it is not working

vijayptcs
Creator II
Creator II
Author

Any suggestion???

Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
vijayptcs
Creator II
Creator II
Author

it is ABC is cyclic group name

Anil_Babu_Samineni

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)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
vijayptcs
Creator II
Creator II
Author

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

vijayptcs
Creator II
Creator II
Author

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
Master II
Master II

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