Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Partner
Partner

Nested set analysis

nested.PNGI want to show the sales from the 20 first countries which sale horror movies, but I don't know how to anidate the function with set analysis to the set analysis. 

Sum({1<Genero={"*Horror*"},Pais={"$(=rank(sum({1<Genero={"*Horror*"}>}Sales),1,1))<=20"}>}Sales)

i though with the dollar-sign expansion, but still doesn't works. 

1 Solution

Accepted Solutions

Re: Nested set analysis

May be this

Sum({1<Genero = {"*Horror*"}, Pais = {"=Rank(Sum({1<Genero = {[*Horror*]}>} Sales), 1, 1)) <= 20"}>} Sales)
1 Reply

Re: Nested set analysis

May be this

Sum({1<Genero = {"*Horror*"}, Pais = {"=Rank(Sum({1<Genero = {[*Horror*]}>} Sales), 1, 1)) <= 20"}>} Sales)