Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Highlighted
giovannarugerio
New Contributor

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)