Count function based on chart variable

Fri, 07 Jun 2013 11:35:59 GMT

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

Re: Count function based on chart variable

sujeetsingh — Fri, 07 Jun 2013 11:43:24 GMT

Use exp likr this

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

Re: Count function based on chart variable

Fri, 07 Jun 2013 12:14:13 GMT

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

topic Re: Count function based on chart variable in QlikView

Count function based on chart variable

Re: Count function based on chart variable

Re: Count function based on chart variable