Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i want to calculate the return product analysis.
sum(sales) <0 that is my return sales.
i want to take the count of total number of return product.
how to write this concept in set analysis formula?
Thanks in Advance
May be this:
=Count({<OrderID = {"=Sum(Sales) < 0"}>}OrderID)
Try with:
Sum(If(sum(sales)<0,1,0))
Can u share sample data ?
Could you please share sample qlikview file?
maybe:
=Count (If(Aggr(Count(unit.id),Sales)>1,unit.id) )
Set analysis is a way of filtering the data prior to evaluating the expression. In this case, I can see a filter criterion, but what would you like to filter? How are sales identified and grouped? The sum is over what dimensions?
Something like this may or may not work depending on the above.
=Sum({<Customer={"=Sum(Sales) < 0"}>} Sales)
sum(if(Sum(Sales)<0,1,0))
(Sum({<Year = {$(=Max(Year))},TransactionType={'INVOICE'},Month=>} #InvNetSales) -
Sum({<Year = {$(=Max(Year))},TransactionType={'CreditNote'},Month= >} #InvNetSales)) <0
that is my return sales
i want to calculate the count of return product
(Sum({<Year = {$(=Max(Year))},TransactionType={'INVOICE'},Month=>} #InvNetSales) -
Sum({<Year = {$(=Max(Year))},TransactionType={'CreditNote'},Month= >} #InvNetSales)) <0
that is my return sales
i want to calculate the count of return product