problems with dimension after aggr

Anonymous — Fri, 18 Nov 2016 14:08:59 GMT

Hi,

I got a problem visualizing my results.

I use aggr twice to sum up values on 2 dimensions and then find the lowest one.

the calculation works fine but somehow the dimension is wrong.

I attached a sample:

first I group bids by lane & provider with

Aggr(sum(bid, [Item ID])

next I try to find the lowest value among the lane bids

Aggr(min(aggr(sum(bid, Item ID])), Division)

As I said the calculation works fine.

Now I do not understand how QV works here

Somehow QV connects the result of the second calculation to a dimension which is not the one related to the value.

When I try to visualize the lowest bid and related information/dimensions does not match the value.

Any ideas appreciated!

topic problems with dimension after aggr in QlikView