Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
prathipsrinivas
Creator
Creator

Top N values based on condition in a textbox

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

 

Prathip
Labels (6)
2 Replies
prathipsrinivas
Creator
Creator
Author

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

Prathip
MayilVahanan

Hi @prathipsrinivas 

Try like below

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

Thanks & Regards,
Mayil Vahanan R