topic Multi Box in QlikView

Multi Box

Mon, 22 Jun 2009 21:53:21 GMT

Hi guys

I'm trying to use a Multi-box to display some data and I'm not sure if it's not working properly or if I misunderstand how the multi box works. I'm working with some medical data that contains some information about a patient.

My understanding is that after selecting something to filter by, say an Order ID, any fields present in the Multi-box which only return one value, like patient age or patient gender, will have that value displayed.

Here is the table example:

Here, the Patient Gender field is displaying in the way that I would expect it to. Out of several possible Genders (Female, Male, Unknown), Female is the one that Order 622 points to, and it is displayed in the multibox. However, for Age At Order... there is also only one piece of data. The possible ages range from 0 -> 120, and in this case when I click on the arrow to view the list of possible ages, there is only one: 79, but it isn't displayed.

This is the case with several other fields in the multibox not shown here. Am I misunderstanding the way the multi box should operate? Should the single possible age be shown?

Multi Box

Anonymous — Mon, 22 Jun 2009 22:56:20 GMT

The reason for this is that you have a second record for your orderID 622. The second record has a NULL value for Age, though. (I know from experience. 🙂 )

Perhaps there is something not correct in your script. Or you could just do a resident load in your script of your table to remove all records where the Age is NULL (probebly not a good idea, though).

Multi Box

Mon, 22 Jun 2009 23:04:19 GMT

ah, I know exactly why this is the case. It's an unfortunate result of the previous thread I created, this weird relational problem, I thought I was bypassing it! Thanks for the answer