Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
giovannarugerio
Partner - Contributor
Partner - 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
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)