Discussion board where members can get started with QlikView.
I have a table with following Field
Then my query is to find Top 2 Vendor over 3 years,please help me out.. if anyone has any solution.
Does that mean, you want Top 2 vendor for each year? Your question is not clear. Please explain
This is one way:
Top =Max(Aggr(Sum(Sales), Vendor, Year))
2nd =Max(Aggr(Sum(Sales), Vendor, Year), 2)
No I want top 2 vendor for over 3 Years,
and then in another table top 2 vendor for over 2 Years
And this is another (eg in calc dimension):
=If(Rank(Aggr(Sum(Sales), Vendor, Year)) <= 2, Vendor)
Check the attachment if that helps.
I have used different personal edition could you please write the code here..