Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm currently trying to write a QlikSense if statement to fill the following criteria - the top 10 suppliers who supply over 10% of our current stock, and with a returns rate of above 35%.
My current syntax is as follows, however this does not work:
=aggr(if(if((Sum(Product.StockToday)/sum(Total Product.StockToday)) >.01 and (Sum(Sales.ReturnsLineTotalGBP)/sum(Sales.GrossSellingPriceGBP)) <.35 ,
Rank(aggr((Sum(Sales.ReturnsLineTotalGBP)/sum(Sales.GrossSellingPriceGBP))), Product.Current_Supplier,4))<11, Product.Current_Supplier),Product.Current_Supplier)
Any tips of solutions would be greatly appreciated - thanks!
Would you be able to provide some sample data and also the expected output based on the data provided
Hi Sunny,
Thanks for your response! Unfortunately, I cannot provide a data sample due to the sensitivity of the information. However, the output expected would be to see suppliers who provide over 10% of total stock ( sum(Total Product.StockToday))) and have a returns rate of over 35% , then show the top 10 ranked by returns rate descending(Sum(Sales.ReturnsLineTotalGBP)/sum(Sales.GrossSellingPriceGBP).
Dummy or mocked up data?Preparing examples for Upload - Reduction and Data Scrambling