topic Re: AGGR calculated dimension in QlikView

AGGR calculated dimension

ilanbaruch — Wed, 20 Mar 2019 10:15:14 GMT

hi all

in my model i have a straight table that i would want to use with a calculated dim,

that will show only customers that their total sales amount is above 100

any ideas ?

advanced thanks

Anil_Babu_Samineni — Wed, 20 Mar 2019 10:25:53 GMT

Try this?

Aggr(Sum(sales)>100, Dimension)

tresB — Wed, 20 Mar 2019 10:27:16 GMT

You might not need aggr or calculated dimension. You could try using set analysis like:

Dimension: Customer

Exp :

Sum({<Customer={"=Sum(Sales)>100"}>}Sales)