Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Anonymous
Not applicable
Author

Please try:


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

sunny_talwar

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

HI plz try this one

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

Not applicable
Author

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

Can you explain what you are trying to do?

Not applicable
Author

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