topic Re: List Box - Combining Two Data Fields in QlikView

List Box - Combining Two Data Fields

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

Hi -

I have a data set that has columns for Home State and Business State. I am interested in creating one list box based on "State" that users can limit the results to. For example if someone selects Vermont from the list box....I want it to return any one who has a home or a business address or both in Vermont within the result set.

Is this possible?

I appreciate any insight you can provide.

Best,

Re: List Box - Combining Two Data Fields

effinty2112 — Mon, 17 Jul 2017 20:47:00 GMT

Hi Ashley,

A Search object might give you what you need. Add a search object with the two fields you want to search against and try it out.

Good Luck

Andrew

Re: List Box - Combining Two Data Fields

vishsaggi — Mon, 17 Jul 2017 20:47:57 GMT

With QV associative logic when you select any value from a list box it will be reflected and show the relevant possible values for the selected. Where exactly you want to show this data like in a table or other objects? Can you share a sample if possible with some expected output.

Re: List Box - Combining Two Data Fields

manas_bn — Mon, 17 Jul 2017 23:27:43 GMT

May be: Create another column by concatenating HOME and BUSINESS States. Then add a List Box and change default search mode to Wildcard. Whenever you search in the new column, any row with HOME OR BUSINESS in that state will get picked.

Fact:

//Precedding load.

//Concatenate both Home and Business into "States" Column

Load *,Home&'-'&Business as States;

Load * inline

[ID,Home,Business

1,VA,VA

2,VA,MN

3,CA,VA

4,CA,MA

5,IL,CA];

Result: (I searched for *VA*)

Cheers!

Re: List Box - Combining Two Data Fields

Anonymous — Tue, 18 Jul 2017 13:04:06 GMT

I didn't know about the search object feature! This would definitely work, but for the application I am building I needed it to be shown as a list box.

Many thanks!