Integrate count in set analysis

Mon, 12 Nov 2012 22:18:01 GMT

I THINK I would like to use a count() expression within a setanalysis of another count as I am trying to accomplisch the following:

I would like to count the amount of companies that have done over 3 productregistrations. My datastructure is setup that every piece of volume has a separate id (productregistration.id).

Therefore if i would like to count the amount of pieces a company has done, i do:

=Count(

RevenueDateMONTH={$(vGlobalMonthSelect)},RevenueDateYEAR={$(vGlobalYearSelect)}

>}Productregistration.Id)

But now i would like to count the amount of companies that have more than 3 productregistrations; and I wanted to approach it something like this:

= COUNT( {<

Count(

RevenueDateMONTH={$(vGlobalMonthSelect)},RevenueDateYEAR={$(vGlobalYearSelect)}

>}Productregistration.Id) ={'>3'}

>} Account.id)

What is the proper way of setting this up?

Re: Integrate count in set analysis

teempi — Tue, 13 Nov 2012 07:59:39 GMT

Hi rtummers,

Try something like this:

= COUNT( {< Account.id={"=Count( {< RevenueDateMONTH={$(vGlobalMonthSelect)},RevenueDateYEAR={$(vGlobalYearSelect)} >}Productregistration.Id) >= 3"} >} Account.id)

-Teemu

topic Integrate count in set analysis in QlikView

Integrate count in set analysis

Re: Integrate count in set analysis