topic Re: sum(A) where B = Max(B) in QlikView

sum(A) where B = Max(B)

Anonymous — Fri, 19 Jan 2018 21:36:50 GMT

If I replace Max(B) with the maximum value of B in the following line.

Sum({$<B={Max(B)}>}A)

It Works as desired but the Max value of B can change and it is not practical to update manually

Anil_Babu_Samineni — Tue, 23 Jan 2018 00:07:18 GMT

If you want to make consultant for irrespect of filters you need {1}

swuehl — Tue, 23 Jan 2018 00:13:09 GMT

Try a dollar sign expansion

Sum({$<B={$(=Max(B))}>}A)

rwunderlich — Tue, 23 Jan 2018 00:19:02 GMT

If you only need to consider one value for max(B), you can do

Sum({$<B={$(=Max(B))}>}A)

If you need a different max(B) for each dimension row, you'll need to code it as:

Sum(If(B=aggr(max(B), dimension), A)

where dimension is the chart dimension(s)

-Rob