topic Re: Aggr function to simply group by in QlikView

Aggr function to simply group by

Thu, 18 Dec 2014 12:18:59 GMT

Hi,

Is there a function which simply groups by a field by a key. Like I want to group by sales by item code.

I don't want to sort out min/max value

I want to do something like [Value] - AGGR(Min([Value]), [ITEMCODE])

So all the values corresponding to an item must display 'x' units less if 'x' is the minimum sales value for that item.

How do I make sure that the [Value] field is grouped by the item code, because if I just use the above simply, my expression errors out...

I want to achieve this in the front end and not the script.

Thanks..

MK_QSL — Thu, 18 Dec 2014 12:25:27 GMT

[Value] - AGGR(Min(TOTAL <ITEMCODE> [Value]), [ITEMCODE])

Thu, 18 Dec 2014 17:39:01 GMT

thank you so much Manish, Could you suggest what would be the expression when we have two keys to aggregate upon?

MarcoWedel — Thu, 18 Dec 2014 18:30:48 GMT

Do you require to display this in a chart?

What are your dimensions?

Anonymous — Thu, 18 Dec 2014 20:11:15 GMT

we use below expression to aggr on two keys:

[Value] - AGGR(Min(TOTAL <ITEMCODE> [Value]), [ITEMCODE],Fieldname)

replace fieldname with your dimension/field

Hope this helps.

Regards

Neetha

Fri, 19 Dec 2014 05:03:06 GMT

yes, in a chart and this expression is itself my calculated dimension.. along with itemcode as the second dimension..