topic Re: How to show top N brands plus a specific brand (Using set analysis) in QlikView

How to show top N brands plus a specific brand (Using set analysis)

prasanthb123 — Sat, 16 Nov 2024 20:31:06 GMT

Hi,

I wanted to show top performing brands plus a specific brand (this brand should always be shown irrespective of performance).

For example:

The user would enter the Top N brands to display using the input box.

Let's say the Top brands that should be displayed in the chart is 4.

The expected output in the chart is A, B, C, X (The brand X should always be included in the chart)

When the top brands to be displayed in the chart is 5 then the output should be A, B, C, D, X

Please help me with the suggestions.

hectormunoz — Thu, 04 Jul 2019 20:10:32 GMT

Hi, you can use something like this

Sum ({<Brand = {"=Rank(Sum(Sales))<4"} + {X} >}Sales)

and change the "4" by a variable

Regards

prasanthb123 — Tue, 09 Jul 2019 09:31:25 GMT

Hi Hectormunoz,

Thanks for your quick help. The solution worked perfectly.