Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

problems with dimension after aggr

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!

0 Replies