Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Not applicable

Set Analysis sum(aggr(max and variable

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:)

6 Replies
neetha_p
Honored Contributor

Re: Set Analysis sum(aggr(max and variable

Please try:


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

Re: Set Analysis sum(aggr(max and variable

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
Contributor II

Re: Set Analysis sum(aggr(max and variable

HI plz try this one

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

Not applicable

Re: Set Analysis sum(aggr(max and variable

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:)

Re: Set Analysis sum(aggr(max and variable

Can you explain what you are trying to do?

Not applicable

Re: Set Analysis sum(aggr(max and variable

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???