Aggr Problem

[pgalvezt]

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!

[#2]

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?

[pgalvezt]

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!

[#4]

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)