topic Re: Set Analysis sum(aggr(max and variable in QlikView

Set Analysis sum(aggr(max and variable

Fri, 11 Sep 2015 10:55:05 GMT

hi everyone:)

i have a question to a set analysis in combination with a variable

my expression
sum({< ID ={"$(ID)"}>} XXX / sum(aggr(max({< ID = {"$(ID)"}>}XXX), YYY,ZZZ))

I ignore also some fields with a statement in the set analysis with XXX=, but it's still not work ....

can anyone help me:)

THANK YOU:)

Anonymous — Fri, 11 Sep 2015 10:57:49 GMT

Please try:

sum({<XXX=, ID ={"$(ID)"}>} XXX )/ sum({<XXX=>}aggr(max({< ID = {"$(ID)"}>}XXX), YYY,ZZZ)

sunny_talwar — Fri, 11 Sep 2015 11:00:34 GMT

Not sure if this is the problem, but you are missing a parenthesis:

=Sum({<0ID = {"$(ID)"}>} XXX) / Sum(Aggr(Max({< ID = {"$(ID)"}>}XXX), YYY,ZZZ))

yadav_anil782 — Fri, 11 Sep 2015 11:05:02 GMT

HI plz try this one

=sum({<XXX=ID ={"$(ID)"}>} XXX / sum({<XXX=>}aggr(max({< ID = {"$(ID)"}>}XXX), YYY ,ZZZ))

Fri, 11 Sep 2015 11:28:58 GMT

it's still not working

it's perfect working if i do this set analysis without aggr. but then i lost my data quality..:(

= SUM({1< Quarter = {"$(vQuarter)"}>} XXX / SUM(AGGR(MAX({1< Quarter ={"$(vQuarter)"}YYY), ZZZ,WWW))

The problem is the AGGR....anyone an idea?

THANK TO YOU ALL:)

sunny_talwar — Fri, 11 Sep 2015 11:39:13 GMT

Can you explain what you are trying to do?

Fri, 11 Sep 2015 11:57:00 GMT

it's little bit difficult but it's a KPI... and i need this calculation for this KPI.

The Problem is the AGGR... i do this set analysis without AGGR it's perfect work but i need this for the KPI..:(

why i have so problems with the AGGR???