topic Re: Fields not responding with search in QlikView

Fields not responding with search

Wed, 07 May 2014 15:55:56 GMT

I have multiple list boxes. As I select data inside of a List Box data in another list box is not appropriately excluded. Of course I need this to work appropriately. Where should I start to find a solution?

Re: Fields not responding with search

tresB — Wed, 07 May 2014 15:56:56 GMT

Data model

Re: Fields not responding with search

ToniKautto — Wed, 07 May 2014 15:59:01 GMT

1. Check the data model and validate that the fields are linked in the data model

2. Make sure the objects are not in different Alternate States

3. Check so that the listbox is not based on a calculated dimension

Re: Fields not responding with search

PrashantSangle — Wed, 07 May 2014 16:00:57 GMT

Hi,

Check your linking between data.

If there is link you are created in those field the it will definitely show you those field.

Regards,

Re: Fields not responding with search

Wed, 07 May 2014 16:05:00 GMT

The fields are linked with one field in the Table Viewer.

The list box that is has data that is not being appropriately excluded had dates in it that were loaded as follows:

[Date of Service],

     Date(Date#( [Date of Service],'MMDDYYYY')) as Servicedate,

     Year(Date(Date#( [Date of Service],'MMDDYYYY'))) as Year,

     Month(Date(Date#( [Date of Service],'MMDDYYYY'))) as Month,

Would this be causing a problem?

Re: Fields not responding with search

PrashantSangle — Wed, 07 May 2014 16:07:50 GMT

Hi,

Change your expression to this,

Date(Date#( [Date of Service],'MMDDYYYY'),'YYYY') as Year,

Date(Date#( [Date of Service],'MMDDYYYY'),'MMM') as Month,

Regards

Re: Fields not responding with search

Wed, 07 May 2014 16:17:05 GMT

Changing the expression to:

Date(Date#( [Date of Service],'MMDDYYYY'),'YYYY') as Year,

Date(Date#( [Date of Service],'MMDDYYYY'),'MMM') as Month,

Kept the data from loading.

Re: Fields not responding with search

Wed, 07 May 2014 16:17:44 GMT

That data would not load this way. I think we may be on the right course though.

Re: Fields not responding with search

PrashantSangle — Wed, 07 May 2014 16:23:39 GMT

Hi,

Is this solve your problem?

Or Still looking for solution?

Regards,

Re: Fields not responding with search

Wed, 07 May 2014 17:06:00 GMT

This did not solve the problem. The data would not reload that why. It did not like the expression.

Re: Fields not responding with search

swuehl — Wed, 07 May 2014 17:43:17 GMT

You would need to tell us more about your data model. Best would be to post a small sample application.

I assume that your tables are either not linked at all (but as I understand, you checked that in your data model), or the key field's values in both linked tables are not matching.

If your key field is [Date of Service], you need to ensure that the values in the tables linked by this field match.

If, for example, you load [Date of Service] field values in one table that are in fact strings, and dual values in the other table, your tables won't link correctly.

Re: Fields not responding with search

Wed, 07 May 2014 17:52:49 GMT

Actually, I am taking columns of data with different names and merging them into one name. This seems to be where the problem is. When I separate out the columns into numerous list boxes, all works. Is there an different way to do this that would not cause a problem? See below:

LOAD [Unique Identifier],

[CPT_1] as CPT

RESIDENT Claims;

CPT:

LOAD [Unique Identifier],

[CPT_2] as CPT

RESIDENT Claims;

CPT:

LOAD [Unique Identifier],

[CPT_3] as CPT

RESIDENT Claims;

Re: Fields not responding with search

Wed, 07 May 2014 18:21:53 GMT

LOAD [Unique Identifier],

[CPT_1] as CPT

RESIDENT Claims;

CPT:

LOAD [Unique Identifier],

[CPT_2] as CPT

RESIDENT Claims;

CPT:

LOAD [Unique Identifier],

[CPT_3] as CPT

Re: Fields not responding with search

PrashantSangle — Thu, 08 May 2014 09:27:39 GMT

Hi,

Why are using same table name?

If you want all the CPT in same table then use concatenate

Like this,

LOAD [Unique Identifier],

[CPT_1] as CPT

RESIDENT Claims;
Concatenate
LOAD [Unique Identifier],
[CPT_2] as CPT
RESIDENT Claims;
Concatenate
LOAD [Unique Identifier],
[CPT_3] as CPT

Regards,

Re: Fields not responding with search

PrashantSangle — Thu, 08 May 2014 09:27:39 GMT

Hi,

Why are using same table name?

If you want all the CPT in same table then use concatenate

Like this,

LOAD [Unique Identifier],

[CPT_1] as CPT

RESIDENT Claims;
Concatenate
LOAD [Unique Identifier],
[CPT_2] as CPT
RESIDENT Claims;
Concatenate
LOAD [Unique Identifier],
[CPT_3] as CPT

Regards,

Re: Fields not responding with search

Thu, 08 May 2014 12:49:48 GMT

That did put all the data into one list, but it did not appropriately eliminate the other data in the others lists when I searched the merge data list. What did work is that I merged all the data into one list with columnname & '|' & columnname and then search the data in the list using *###*