topic Re: List Box with Code and description in QlikView

List Box with Code and description

Johnnyg248 — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: List Box with Code and description

hopkinsc — Wed, 06 Mar 2019 14:53:41 GMT

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

is that what you mean?

Re: List Box with Code and description

rwunderlich — Wed, 06 Mar 2019 15:08:32 GMT

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

Re: List Box with Code and description

hopkinsc — Wed, 06 Mar 2019 15:22:50 GMT

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)

Re: List Box with Code and description

ziadm — Wed, 06 Mar 2019 15:38:47 GMT

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

Re: List Box with Code and description

Johnnyg248 — Wed, 06 Mar 2019 16:09:42 GMT

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!

Re: List Box with Code and description

hopkinsc — Wed, 06 Mar 2019 16:16:30 GMT

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)

Re: List Box with Code and description

hopkinsc — Wed, 06 Mar 2019 16:26:00 GMT

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

Re: List Box with Code and description

Johnnyg248 — Wed, 06 Mar 2019 16:46:44 GMT

Got it!

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

Re: List Box with Code and description

hopkinsc — Wed, 06 Mar 2019 16:51:48 GMT

Glad it helped 🙂