List Box with Code and description

[Johnnyg248]

We have a table that contains a 3  character code and 10 character description

I do have a field that has the concatenation of 3 character code, followed by description which I have

used to create a list box

I would like to use the 3 character code as part of the  selection criteria for my straight table but not sure best way to do this

I know in vb there is a display and value field but not sure about qlik view

Thanks!

[hopkinsc]

So you want to have a column in the straight table with the 3 character code in?

is that what you mean?

[rwunderlich]

Do you have the original 3 character code as a field in your data model?  If so, just use that field name in the straight table. 

-Rob

[hopkinsc]

Exactly as @rwunderlich  says, use the single field in the table. if you dont have it then you could use a calculated dimension instead left(combined_field,3)

[ziadm]

Hi
There is no object in Qlik similar to VB drop down combo box that takes value and display properties. Suggest to have the description in the straight table and you can create a search object and have the code in the search

[Johnnyg248]

Thanks for all the responses!

I'm new to qlikview and have to say the response time is very impressive!

I'm thinking perhaps I'm not explaining my question very well  (Combined with my newness to qlikview) 🙂

I attached a screen shot that I think illustrates what I'm looking for

If I select a category or 2 in the list box...I only want records in the straight table that match the category(ies)

and as you can see in the screen shot I'm not getting that result

conceptually I understand the comments...guess I'm confused as to implementation

Perhaps if someone could post a qvw?

Really appreciate your patience!

[hopkinsc]

It looks like its an issue with your data model. Can you post a sample? Maybe scramble any sensitive data first (you can do that in QlikView - Doc properties>scramble tab and choose the fields you wish to scramble)

[hopkinsc · Accepted solution]

a very simple example attached to show creating a combined field and using it to make selections

[Johnnyg248]

Got it!

Thanks for the sample  ... That cleared it up!

[hopkinsc]

Glad it helped 🙂