Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
List of top 20 Vendor in terms of avg sales in 3/6/12 months ( Overall as well as at regional level)
set analysis in Qliksense
@Dolly123 can you share a sample data and the expected output ?
No but give me ideas how to write
@Dolly123 Could you please try something like below:
if(rank(avg({<OrderDate={">=$(=Date(Max(OrderDate)-90,'MM/DD/YYYY'))<=$(=Max(OrderDate))"}>}LineSalesAmount))<=10,ProductName)
The above expression is for last 3 months. You can change the expression as per the need. This is just to give you an idea on how to write it.
i need 3 months , 6 months , 12 months
let say individuals or in 1 set code
@Dolly123 The expression that I mentioned above is for 3 months.
For 6 months, please see the below expression:
if(rank(avg({<OrderDate={">=$(=Date(Max(OrderDate)-180,'MM/DD/YYYY'))<=$(=Max(OrderDate))"}>}LineSalesAmount))<=10,ProductName)
For 1 year, Please see the below expression:
if(rank(avg({<OrderDate={">=$(=Date(Max(OrderDate)-365,'MM/DD/YYYY'))<=$(=Max(OrderDate))"}>}LineSalesAmount))<=10,ProductName)