Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Johnnyg248
Contributor III
Contributor III

List Box with Code and description

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!

 

1 Solution

Accepted Solutions
hopkinsc
Partner
Partner

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

View solution in original post

9 Replies
hopkinsc
Partner
Partner

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
Partner
Partner

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
Specialist
Specialist

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
Contributor III
Contributor III
Author

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
Partner
Partner

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
Partner
Partner

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

View solution in original post

Johnnyg248
Contributor III
Contributor III
Author

Got it!

 

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

hopkinsc
Partner
Partner

Glad it helped 🙂