topic Multibox Key and Codes in QlikView

Multibox Key and Codes

Tue, 05 Oct 2010 18:20:13 GMT

Hello,

I'm having some trouble figuring out how to toggle something with the multibox.

Here's the setup:

Table1:

Load Taxonomy, .... From ....

TaxonomyReference:

Load Taxonomy, [Taxonomy Category] From ....

Basically, I have two variables: Taxonomy (which is a coded entry and also a Key) and Taxonomy Category (The descriptions to taxonomy).

In the multibox, I want to have the descriptions of taxonomy showing. Typically I would use Taxonomy Category as a dimension. My problem with this is, it shows everything in the list when it only needs to show when the corresponding taxonomy code is used in table1.

Is there a way around this?

Multibox Key and Codes

johnw — Tue, 05 Oct 2010 18:37:18 GMT

Not sure I understood the question, but maybe this?

Table1:
Load Taxonomy, .... From ....

TaxonomyReference:
Load Taxonomy, [Taxonomy Category] From ....
Where exists(Taxonomy)

Also, while not necessary, I'd personally just left join the category onto Table1 unless there are a lot of additional fields you aren't showing in the example, or Table1 is so large as to cause performance problems for the load:

Table1:
Load Taxonomy, .... From ....

Left Join (Table1)
Load Taxonomy, [Taxonomy Category] From ....
Where exists(Taxonomy)

Multibox Key and Codes

Tue, 05 Oct 2010 18:42:23 GMT

Ahh, that's smart didn't think of it like that.

I guess I could join them in Qlikview. Didn't think of it that way because we pull this stuff off and into a txt file so the more columns we download the bigger the file, the longer the download takes etc. So yes, there are a lot of additional fields. I'll give it a shot for a few minutes to see if it behaves the way I was searching for.

Multibox Key and Codes

Tue, 05 Oct 2010 21:32:28 GMT

That worked out really well and exactly how I wanted it to.

Thanks John.