Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
misevicius_paul
Contributor
Contributor

Two lists in ListBox

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 110User1Product 5
Product 233User1Product 6
Product 339User1Product 2
Product 434
Product 57
Product 638
Product 79
Product 821
Product 92
Product 1021

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?

0 Replies