topic Need help with Table box and List Box in QlikView

Need help with Table box and List Box

Sat, 19 Dec 2015 19:24:28 GMT

Hello,

I'm new to Qlikview and I've been playing a bit with it, creating graphs and learning how to do things. Right know I'm trying to do something that I think is quite simple but I'm struggling with.

I have loaded the following table and created two list box, one for sender and the other for addresee:

Sender	Addresee
00140	00170
00150	00180
00160	00140

What I'm triyng to do is create a Table box that shows all the information related to a code. For example, if I select in Sender's List box 00140 I would like the table box to show:

Sender	Addresee
00140	00170
00160	00140

How can I do that?

Thanks in advance.

Re: Need help with Table box and List Box

robert_mika — Sun, 20 Dec 2015 09:04:06 GMT

So you want to see the address associated with the Sender and the sender code if is the same as the address?

Re: Need help with Table box and List Box

Sun, 20 Dec 2015 09:26:44 GMT

‌Yes, what I want is if I select a code either in the Sender or Addresee list box to display in the table box all rows where that code appears .

Re: Need help with Table box and List Box

effinty2112 — Sun, 20 Dec 2015 11:04:55 GMT

Hi,

Try this script:

Messages:

LOAD

RecNo() as MessageID,

LOAD * INLINE [

Sender, Addresee

00140, 00170

00150, 00180

00160, 00140

];

Correspondants:

Load

MessageID,

Sender as PersonID

Resident Messages;

LOAD

MessageID,

Addresee as PersonID

Resident Messages;

This will give you a data model like this:

Selecting PersonID will select the associated messages and so the Senders and Addresees will appear in the tablebox. Include the Message ID in your tablebox if you want to see individual messages.

Cheers