Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist III

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
Highlighted
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
Highlighted

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

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)
Highlighted
Specialist III
Specialist III

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

how can I get it?

Highlighted
Master II
Master II

May be as below:

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

Highlighted

Why not this?

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

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

In text box use the below:

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

View solution in original post

Highlighted
Specialist III
Specialist III

thanks aall.,

I will check and update you.