Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

count of region

Hi all,

I have pie chart with  count of regions  it will display  each region count

but my requirement is

if I select any region in pie chart ---      that particular  region count should display in text object 

how can I write the expression in text object dynamically?

1 Solution

Accepted Solutions
trdandamudi
Master II
Master II

In text box use the below:

=If(GetSelectedCount(Region) >0, Region &'-' &Count(Region),0)

View solution in original post

6 Replies
Anil_Babu_Samineni

It should automatic, no need to manipulate here. Count(Measure) is enough i believe

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
soniasweety
Master
Master
Author

I need to ddisplay in text box along with the selected region

how can I get it?

trdandamudi
Master II
Master II

May be as below:

=If(GetSelectedCount(Region) >0, Count(Region),0)

Anil_Babu_Samineni

Why not this?

=GetFieldSelections(Region) & ' - ' & Count(Measure)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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

In text box use the below:

=If(GetSelectedCount(Region) >0, Region &'-' &Count(Region),0)

soniasweety
Master
Master
Author

thanks aall.,

I will check and update you.