Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
giovannarugerio
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
sunny_talwar

May be this

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

View solution in original post

1 Reply
sunny_talwar

May be this

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

View solution in original post