topic Re: Set Analysis in QlikView

Set Analysis

pageomet — Tue, 04 Nov 2014 19:30:13 GMT

Hi;

I'm trying to count all approved dealers with a listingdate > registrationdate. How do I count everything that the current selection excludes? See formula below:

=count(Aggr(if(Max(TOTAL LISTINGDATE), DEALER) > REGISTRATIONDATE, DEALERSTATUS = 'Approved' ,DEALER))

Thanks,

Ometrice Page

Re: Set Analysis

Anonymous — Tue, 04 Nov 2014 20:42:02 GMT

count({$<DEALER=P({$<LISTINGDATE={">REGISTRATIONDATE"}>}DEALER)>}DEALER)

depending on your data model, you may need:

count({$<DEALER=P({$<LISTINGDATE={">REGISTRATIONDATE"}>}DEALER)>}distinct DEALER)

Re: Set Analysis

Wed, 05 Nov 2014 00:46:07 GMT

Hi Ometrice!

Steve is right, except he forgot the DEALERSTATUS in his SET expression:

count({$<DEALER=P({$<LISTINGDATE={">REGISTRATIONDATE"}, DEALERSTATUS = {'Approved'}>}DEALER)>}DEALER)

Re: Set Analysis

Anonymous — Wed, 05 Nov 2014 00:53:57 GMT

Nice catch!

Re: Set Analysis

pageomet — Wed, 05 Nov 2014 12:19:49 GMT

How do I exclude the counts from the current selection?

Re: Set Analysis

Anonymous — Wed, 05 Nov 2014 14:17:56 GMT

Try this:

count({1-$<DEALER=P({1-$<LISTINGDATE={">REGISTRATIONDATE"}, DEALERSTATUS = {'Approved'}>}DEALER)>}DEALER)