Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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