Fields not responding with search

[#1]

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?

[tresesco]

Data model

[ToniKautto]

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

[PrashantSangle]

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,

[#5]

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?

[PrashantSangle]

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

[#7]

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. 

[#8]

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

[PrashantSangle]

Hi,

Is this solve your problem?

Or Still looking for solution?

Regards,

[#10]

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