Expression based on dimension that is not in a chart

Anonymous — Thu, 21 Jan 2016 14:47:15 GMT

Hi,

First of all, I'm a rookie in QV.

My problem is that I can't write a formula, that would count number of items that had sales less than 500 Eur per period.

So, I tried to write IF(SUM(Sales_amount)<500, Count(Distinct(item)).

The thing is that my chart contains not items (as dimension) but item groups and item type, but Sales_amount must be based on items, not on item groups.

So I know that somehow I should use aggr function, but I don't understand where and how. Please, help me.

Re: Expression based on dimension that is not in a chart

Thu, 21 Jan 2016 18:34:26 GMT

Try like below with multi AGGR functions

IF(AGGR(Sum(Sales_Amount),item) < 500 , AGGR(Count(item),item_type))

topic Expression based on dimension that is not in a chart in QlikView

Expression based on dimension that is not in a chart

Re: Expression based on dimension that is not in a chart