Two lists in ListBox

misevicius_paul — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a problem with listbox.

Situation: I have a field with 10 distinct products with numberOfOrders, and One table with with list of products, which user have to see.

I need to show top5 products by numberOfOrders PLUS those products from other table.

Product 1	10	User1	Product 5
Product 2	33	User1	Product 6
Product 3	39	User1	Product 2
Product 4	34
Product 5	7
Product 6	38
Product 7	9
Product 8	21
Product 9	2
Product 10	21

If I want to show only ranked products I use if(aggr(rank(sum(NumOfOrders),4),Product)<=5,Product. If I want to show only User's specific products, I use if(Product=[User's product], Product).

But I don't find the way how to merge those lists.

Any suggestions?

topic Two lists in ListBox in QlikView

Two lists in ListBox