topic Re: Aggregate calculated dimension in QlikView

Aggregate calculated dimension

nesonica — Sat, 16 Nov 2024 04:05:46 GMT

Hi guys! 🙂

I am trying to build a calculated dimension with an aggregation of something like this here and I have no clue how to build that without errors. Could you help me please? 🙂

aggr (

if(SALES_S > 0,S,0)

if(SALES_H > 0,H,0)

if(SALES_I > 0,I,0)

)

Re: Aggregate calculated dimension

jaibau1993 — Thu, 21 Mar 2019 11:02:34 GMT

Hi!

I am not sure of what is your desired output but we can start by writting correctly that Aggr function. Aggr takes at least two arguments, the first one is an expression (as you did) but it needs a second argument which especifies the dimension for which you are aggregating the expression of the first argument. You may aggregate for more than one dimension:

Aggr( Expr, Dim1, Dim2, Dim3, ...)

So, your Aggr needs a dimension (or more).

Hope it helps,

Jaime.

Re: Aggregate calculated dimension

nesonica — Thu, 21 Mar 2019 12:59:03 GMT

this worked perfectly for me, thanks so much!