topic Re: Selection in Listbox in QlikView

Selection in Listbox

Fri, 02 Sep 2011 17:38:17 GMT

Helly everyone,

i have a database table that contains the articles sent to our clients.
For each article sent, we store:

- the article (Field Article)

- the package-nb in which the article was sent (Field PackageNb)

- the corresponding client's order number (Field OrderNb)

Now, I need to create a ListBox that shows for a certain Order-Nb and Article, what Packages contain that specific article.

I tried to create a ListBox with dimension PackageNb.

Then I created the following expression:

if(OrderNb=12345 and Article='pencil123', PackageNb)

But I dont get any values as a result. Could anyone tell me what I am doing wrong here, please?

Thanks a lot in advance!

Re: Selection in Listbox

john_duffy — Fri, 02 Sep 2011 18:10:02 GMT

Hi Stef.

I was able to get your expression to work in a list box. Set List Box 1 in the attached application. Also, I created List Box 2 which will display the value for PackageNb if the user selects an OrderNB and Article.

Let me know if this helps or if I am not understanding the issue.

John.

Selection in Listbox

Wed, 07 Sep 2011 11:10:55 GMT

That's just what I needed. Your example is great! Thanks a lot!