topic help on set analysis in QlikView

help on set analysis

NavinReddy — Fri, 08 Nov 2013 10:39:41 GMT

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

Fri, 08 Nov 2013 11:01:39 GMT

Hi Niru,

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

/Ida

NavinReddy — Fri, 08 Nov 2013 11:12:47 GMT

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

Fri, 08 Nov 2013 11:15:32 GMT

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