Top 20 set analysis

[Dolly123]

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 

[Taoufiq_Zarra]

@Dolly123  can you share a sample data and the expected output ?

[Dolly123]

No but give me ideas how to write

[sidhiq91]

@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.

[Dolly123]

i need 3 months , 6 months , 12 months 

let say individuals or in 1 set code

[sidhiq91]

@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)