Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count function based on chart variable

Hi all,

I've developed a pivot displaying revenue by customers (and other dimensions)

This is linked to an input box for "Show customers with rev above: variable"

It works perfectly for the chart and limits it as it should, but I also display a box on the screen with a count of customers in the current selection.

As this variable is not actually selecting the customers (just supressing view) the count is not updating.

So I could have three in my pivot but still be saying 46'732 customers in selection .

I've tied the following but so far have been unable to jiggle it correctly.

='# of Holding Companies in Selection  '&

Count(IF(Sum(TOTAL(<[Holding Company]>Revenue) > VRevenue),[Holding Company]))

I want to count (distinct if poss.) Holding Company, if the revenue at the holding company is greater than VRevenue

Any ideas ?

Thanks

T

2 Replies
sujeetsingh
Master III
Master III

Use exp likr this

if(sum(total(<HoldingCampany>Revenue)>VRevenue),Count(Distinct---),null())

Not applicable
Author

Sorry Guys...
Both of those are just giving me the old " - " in my text box.