topic Re: Assign value based on count in QlikView

Assign value based on count

Anonymous — Fri, 23 Oct 2015 21:03:54 GMT

I have 3 dimensions: Accounts Locations Products An Account has multiple Locations, each with varying numbers of Products. I would like to flag the Location at each Account with the highest number of Products with "Primary". Every other Location per Account would have an alternate flag "Secondary" Any ideas?

Re: Assign value based on count

sinanozdemir — Fri, 23 Oct 2015 21:17:27 GMT

Hi Jonathan,

I don't know your data so I am just guessing that you have numbers in Products dimension. If so, you can use Max(Total <Accounts> Products) function:

Hope this helps.

Re: Assign value based on count

Anonymous — Fri, 23 Oct 2015 21:36:34 GMT

That is very helpful and close but not quite. I think the issue is products are individual records rather than just a number on a record.

Re: Assign value based on count

sunny_talwar — Fri, 23 Oct 2015 23:07:37 GMT

May be this?

=If(Count(Product) = Max(TOTAL <Accounts, Location> Aggr(Count(Product), Accounts, Location, Product)), 'Primary Location', 'Secondary Location')