topic Re: Top N values based on condition in a textbox in QlikView

Top N values based on condition in a textbox

prathipsrinivas — Sat, 16 Nov 2024 17:52:00 GMT

Hi Experts,

I have a requirement where I need to show a list of N products in a text box .

That is, list of all the products whose sales are less compared to last year, it might be 5 or 10 or random number.

I have tried Firstsortedvalue but as you all know which gives one Product as a Output.

I am stuck on how to proceed further here.

Any suggestions are most welcome.

Thanks in advance,

Prathip

Re: Top N values based on condition in a textbox

prathipsrinivas — Fri, 06 Nov 2020 14:14:32 GMT

Hi,

I have found a work around by Creating Straight table and limit the Dimensions using the Condition Sum(current year)-sum(previousyear)<0 and hide the expression column in presentation and format in such a way it looks like text box. With this, we can make selections as well.

Please let me know if you have any alternate solutions.

Thanks,

Prathip

Re: Top N values based on condition in a textbox

MayilVahanan — Sat, 07 Nov 2020 02:14:58 GMT

Hi @prathipsrinivas

Try like below

=Concat(Distinct {<Product={"=Sum(current year)-sum(previousyear)<0"}>}Product, ',')