Discussion Board for collaboration related to QlikView App Development.
Hi everybody I'm new in the Qlikview Community. I have an issue and I haven’t figured it out yet so maybe you could help me. Here are my datas:
I have this expression for the column Quantity recalculated and it works:
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 :
Thanks in advance for your help
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]))
View solution in original post
Use a TOTAL qualyfied
Sum(TOTAL <[Salesman name],[Qty]> $(v_Qty_recalculated_LY))
I assume Qty field is a dimension
Thank you very much, this solution works.
Have a good day