help on set analysis

[NavinReddy]

hi All,

Could some one help me

How could i display Top 1 records in Qlikview,

How could i display Top 2 records in Qlikview,

How could i display Top 3 records in Qlikview,

Thanks IN Advance

Niranjan

[#2]

Hi Niru,

Sounds like you are looking for dimension limits and limit on largest n values. Check dimension limits tab in chart.

/Ida

[NavinReddy]

yes that is one option ,but it not suites for my requirement

requirement is:

i have one multibox in that if i select one value ,i should compare that value in three values

eg:

if i select comedy film in multibox ,there film i should compare top theree comedy movies ,

in that i should fetch and display top 1,2,3 movies

Some one help me very Urgent

Thanks & Regards

Niranjan

[#4]

Hi,

Sum({<Product = {"=rank(sum(Sales), 4)<= 20"}>} Sales)

For the Top 20

If you want to set the sales used to rank (if you want the Top 2à of the Brand 10 for ex):

Sum({<Product = {"=rank(sum({<Brand = {10}>} Sales), 4)<= 20"}>} Sales)

Fabrice