topic Ignore a filter with sum total aggr in QlikView

I have this expression for the column Quantity recalculated and it works:

if($(v_Qty_LY)=0,($(v_Qty_Total_LY)/$(v_Nb_Salesman)),$(v_Qty_LY))

I tried to create an expression to calculate the total quantity by product but it doesn't count the value that replaced the 0.

For example, I don't find 15 but 12. Here is the expression that I created :

Sum(Aggr(NODISTINCT($(v_Qty_recalculated_LY)),Material_Code))

Thanks in advance for your help

Regards

Loreen

Sunny_talwar · ‎01-08-2019

May be try this

Sum(TOTAL <[Product n°]> Aggr(
If($(v_Qty_LY) = 0, ($(v_Qty_Total_LY)/$(v_Nb_Salesman)),$(v_Qty_LY))
, [Product n°], [Salesman name]))

This solution worked. But now, I'd like to keep the quantity total by product, even when I filter the salesman.

For example, when I filter the Salesman PT, I have

And I'd like to have

I'd like to have the same result as with this expression

Sum(Aggr(NODISTINCT($(v_Qty_recalculated_LY)),Material_Code))

except that this expression does not take into account when the qty is recalculated, like I said in my previous post.

I tried by adding {<Salesman_name=,Salesname_Code=>} in my expression but it does not work.

Do you have any solution ?

Thanks in advance

Loreen

Ignore a filter with sum total aggr