Discussion Board for collaboration related to QlikView App Development.
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
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
Try like below
=Concat(Distinct {<Product={"=Sum(current year)-sum(previousyear)<0"}>}Product, ',')