Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Loreen
Contributor III
Contributor III

Calculate Sum Aggr No distinct

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:

Product n°Salesman nameQtyQty recalculatedTotal quantity by product
1PT5515
1PL5515
1PM2215
1PO0315
2PT9974
2PL151574
2PM363674
2PO141474

 

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

 

1 Solution

Accepted Solutions
sunny_talwar

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

3 Replies
albert_guito
Creator II
Creator II

Hi,

Use a TOTAL qualyfied

Sum(TOTAL <[Salesman name],[Qty]> $(v_Qty_recalculated_LY))

I assume Qty field is a dimension

 

Ag+

Ag+
sunny_talwar

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]))
Loreen
Contributor III
Contributor III
Author

Thank you very much, this solution works.

Have a good day

Regards

Loreen