topic Re: Set Analysis, Aggr and priorities in QlikView

Set Analysis, Aggr and priorities

Fri, 28 Mar 2014 13:32:48 GMT

Hi,

After so many tries, I need some help!!!

Expression:

=sum({$<year1={'2012'}, year2=>} aggr(totalvalue,codemp))

It seems that first QV is executing "aggr(totalvalue,codemp)" without taking account only fields filtered by "{$<year1={'2012'}, year2=>}".

I also tried, for example:

sum({$<codemp = P({$<year1={'$(=getfieldselections(year2))'},year2=>})>} aggr(totalvalue,codemp)

Can you help me? What is the correct way? Because totalvalue needs to be aggregated by codemp...

Thanks a lot.

Re: Set Analysis, Aggr and priorities

Aurelien_Martinez — Fri, 28 Mar 2014 13:35:04 GMT

Hi,

You can try :

=sum({$<year1={'2012'}, year2=>} aggr(Sum(totalvalue),codemp))

Aurélien

Re: Set Analysis, Aggr and priorities

alexandros17 — Fri, 28 Mar 2014 13:35:54 GMT

try this:

Sum(Aggr(sum({$<year1={'2012'}, year2=>} totalvalue),codemp))

Re: Set Analysis, Aggr and priorities

jonathandienst — Fri, 28 Mar 2014 13:37:49 GMT

I am not sure what you are trying to do, but have you tried a straight table with codemp as the dimension and

=Sum({$<year1={'2012'}, year2=>} totalvalue)

as the expression?

HTH

Jonathan

Re: Set Analysis, Aggr and priorities

Fri, 28 Mar 2014 14:17:09 GMT

Thanks for all...

I have a BI very complex joining a lot of systems. I have a sheet that is a summary of the information, so I need to manually set and clear some fields.

What I need in this expression:

1. year1 is empty and needs to be equal to year2

2. year2 needs to be cleared

3. sum totalvalue aggregated by codemp

4. it will be in a text box

Re: Set Analysis, Aggr and priorities

Fri, 28 Mar 2014 14:21:46 GMT

try below

aggr(Sum({$<year1={'2012'}, year2=>} totalvalue),codemp)

aggr(sum( if Year1= 2012 and year2<>0, totalvalue)),codemp)

Re: Set Analysis, Aggr and priorities

Josh_Good — Fri, 28 Mar 2014 16:35:43 GMT

Try

=sum({$<year1={'2012'}, year2=>} aggr({$<year1={'2012'}, year2=>} totalvalue,codemp))

Re: Set Analysis, Aggr and priorities

Fri, 28 Mar 2014 18:27:19 GMT

Hello,

Your expression makes sense... it's exactly what I need. I need to show to "AGGR" that it needs to respect the set analisys.

But after AGGR I can not have set analisys "{}".... It should have some aggregate function as well.

Thanks.