Usage of the multibox (in combination with Aton attributes)
Hello all,
today, I'm facing a complex situation regarding the usage of the multibox.
Let me explain: I'm creating 'a kind of' search engine in QlikView (V9 SR5). This search engine searches through an existing database (Modultek's Aton 5). In this database, allmost every item has on of more attributes. This attributes are stored in a table. The structure of this (attribute) table (in ATON 5) is:
------- ITEM DATA -------
- ITEM_ID (The item id: e.g. 123 or 345)
- HEADER_CODE (The attribute name: e.g. LENGTH or VOLTAGE)
- TECH_VALUE (The attribute value: e.g. 30 or 12)
------------------------------------
So, every ITEM_ID has several HEADER_CODEs with an TECH_VALUE. An ITEM_ID can have more HEADER_CODEs. An HEADER_CODE has only one TECH_VALUE.
Now the challenge: I would like the following: An multibox with only the applicable attributes (ITEM_ID's resulting from the initial search). However, if I simply import this table, the structure isn't the way I want it. I would like to have alle the possible HEADER_CODES beneath eachother with a selection box (with TECH_VALUE) behind every HEADER_CODE in a multibox. To make this possible, I have to (somehow) transform this table.
Has anyone of you got any experience with this problem or a good idea to solve it?
this would solve the problem of visiblity, however, it didn't work. I would like to hide the whole field which isn't applicable at that moment. "Hide excluded values won't do this" (on my system, maybe I'm doing something wrong?).
I understand that your multibox will always have three fields, ITEM_ID, HEADER_CODE and TECH_VALUE, and they will be always visible. What you don't want to show is those values in HEADER_CODE for a specific ITEM_ID when they don't apply. Is this correct?
Depending on your database, you may use a hierarchy table, kind of a dropdown, but this won't work with the multibox.
first of all: thank you for your time and your reply (replies). I think there is some discrepancy in our thoughs.
What I would like to see is: a multibox with only applicable fields (HEADER_CODE). All the field in the selection box with no options (TECH_VALUE) have to disappear somehow. So, depending on the ITEM_ID, fields (HEADER_CODE) are shown. If I have to change the table format of Aton, so be it.
.png "Miguel_Angel_Baeyens"){kind=avatar}
