topic Re: Set Analysis two conditions (rank) in QlikView

Set Analysis two conditions (rank)

ssmhg2712 — Sat, 16 Nov 2024 17:54:56 GMT

Dear all,

i need your support for a chart with two set analysis conditions.

It´s a long list of articles with price. I want to show only the top10 articles without articles of type "Mono*"

Each of the condition is working and is showing 10 results.

But if i combine the two conditions i only get 6 results, as there are 4 articles in the TOP10 with articletype = "MONO".

Sum({<[articletype] -= {"MONO*"}, %article = {"=Rank(Sum(price*qty))<=10"}>} (price*qty))

Thank you for any help!

Kind regards, Sven

MayilVahanan — Tue, 27 Oct 2020 10:31:26 GMT

Try like this

Sum({<[articletype] -= {"MONO*"}, %article = {"=Rank(Sum({<[articletype] -= {'MONO*'}>}price*qty))<=10"}>} (price*qty))

ssmhg2712 — Tue, 27 Oct 2020 11:31:53 GMT

Hi,

thank you very much for your answer!

Your expression still showed only 6 results, but according to your proposal i found the correct one:

Sum({< %article = {'=Rank(Sum({<[articletype] -= {"MONO*"}>}price*qty))<=10'}>} price*qty))

Thank you very much for you help!

Kind regards,

Sven