How can I use Set Analysis AGGR function to discount duplicate vendor names (highlighted in yellow) based on Document Upload Date or Invited Status?

Fri, 30 Oct 2015 09:23:10 GMT

Dear Community Users,

I have tried using this Set Analysis AGGR function in the Expression tab of a chart object but it only displays the minimum DocUploadDate to display the unique vendor count (InviteesStatName). How do I go about displaying the vendors with a blank DocUploadDate as well? Or how do I go about displaying the vendors with Invitees_Status as "invited". For your information, ALL vendors with a blank DocUploadDate is EQUAL to Invitees_Status="Invited". So either component will do.

There are thousands of other vendors (not shown here because I only singled out the duplicates) that have no DocUploadDate and/or Invitees_Status="Invited". They have no other statuses. Duplicate vendors are defined as a vendor having more than one status such as "Invited", "Approved", "Draft", "Purged" and so on.

Your prompt assistance would be greatly appreciated.

Count(AGGR(min([DocUploadDate]), InviteesStatName, [Invitees_Status]))

Re: How can I use Set Analysis AGGR function to discount duplicate vendor names (highlighted in yellow) based on Document Upload Date or Invited Status?

Gysbert_Wassenaar — Fri, 06 Nov 2015 15:03:45 GMT

Count({<[Invitees_Status]={'Invited'}>}InviteesStatName)

topic How can I use Set Analysis AGGR function to discount duplicate vendor names (highlighted in yellow) based on Document Upload Date or Invited Status? in QlikView

How can I use Set Analysis AGGR function to discount duplicate vendor names (highlighted in yellow) based on Document Upload Date or Invited Status?

Re: How can I use Set Analysis AGGR function to discount duplicate vendor names (highlighted in yellow) based on Document Upload Date or Invited Status?