topic Re: aggr and max question in QlikView

aggr and max question

jduluc12 — Fri, 15 Nov 2024 23:15:07 GMT

Hi,

I have a data set like this.

I want to make a chart to show

for the amount column the expression is

sum({<rank={"$(=only(aggr(max(rank),customer)))"}>}amount)

but it is not working and giving me all zero values.

what am I missing here?

thanks.

richard_chilvers — Tue, 26 Jan 2021 09:45:52 GMT

Hi

Could you explain the logic behind the chart you want - what do you mean by 'highest rank' - I don't think it is obvious from your example.

jduluc12 — Tue, 26 Jan 2021 09:55:36 GMT

there is a rank column in the data set.

so whichever amount has the highest rank, we need to show the amount of that

for example, cust2 has 3 rows with ranks 1, 2, and 3. so the chart should show the amount 45 for cust 2, which is the amount for rank 3.

I hope it is clear now.

MayilVahanan — Tue, 26 Jan 2021 10:41:26 GMT

Try like below

Dim: Customer

Exp: Aggr(If(rank=Max(Total<Customer>rank),sum(amount)),Customer,rank)