topic Re: issue with set analysis in QlikView

issue with set analysis

domiho123 — Wed, 07 Oct 2015 07:43:30 GMT

Attached example shows my problem with set analysis.

Basically, the expression

=MaxString({<cost = {"$(=Max(cost))"}>} office)

is not returning the expected value. It seems that in the straight table the dimension 'customer' is not taken into account.

Please advice.

Dominique.

hic — Wed, 07 Oct 2015 14:02:06 GMT

You cannot use Set Analysis for this.

Instead, use

=Only(Aggr(If(cost=Max(total <customer> cost),office),customer, office))

HIC

swuehl — Wed, 07 Oct 2015 14:21:38 GMT

In your specific setting, also this may work:

=FirstSortedValue(office, -cost)

domiho123 — Wed, 07 Oct 2015 16:58:30 GMT

Thank you both for your swift help. Both solutions work and give me a better insight in how to this in the future.

The best,

Dominique