topic Re: Aggr Problem in QlikView

Aggr Problem

pgalvezt — Fri, 07 Nov 2014 18:25:27 GMT

Hello,

I have this:

Sum(Aggr(

If(po_ord_date = '$(vMaxDate)', Sum(Valorizado)),Codigo))/po_ex_rate2

Works fine when I select Codigo (Code). But when there is no selection Qlikview Shows Nothing

I have tried with:

Sum(Aggr(

If(Aggr(po_ord_date = '$(vMaxDate)', Sum(Valorizado))),Codigo))/po_ex_rate2

But Only shows Zeros.

Can anyone fix that aggregation?

Thanks!

Re: Aggr Problem

Fri, 07 Nov 2014 19:00:27 GMT

Could you write out what your trying to do?

If you are trying to display the sum of the Valorizado on a specific day by Codigo this expression may be to ambiguous without the context of a selection. If this is in a chart try making Codigo one of the dimensions?

Re: Re: Aggr Problem

pgalvezt — Fri, 07 Nov 2014 19:23:04 GMT

Hi Tyler,

I'm Trying to show the sum(Valorizado)/po_ex_rate2 po_ex_rate2(Change type Dollar)

Yes, is in a pivot (Codigo is one of my dimmensions).

I attached a Test qvw what I want is to show all vallues in the second (below) pivot, just show the second value, the reason is Ihave a variable that show the max date. But if I remove this shows other value that I don't want to show.

Just to show all values in the second pivot.

Thanks!

Re: Aggr Problem

Fri, 07 Nov 2014 20:23:10 GMT

I took a quick look at your data - I am pretty sure it is happening because vMaxDate only lines up with one Codigo's po_ord_date. If you drop a table with those two fields you should see the same. I am not sure why the selecting makes the chart look past the date condition.

You could probably rewrite these statements more simply with set analysis and get the same result:

sum({<po_ord_date={'$(vMaxDate)'}>}Valorizado)