How to create list boxes that filter a subset of data only?

[#1]

Hi guys. I have a problem I'm trying to figure out. I've got a table that includes two similar record types with a "Record Type" field.. I want to be able to filter each record type independently. The way I do this now is to split the table into 2, but this has doubled the amount of dimension tables required.

So say I have a filter of Color, with possible values red, yellow, and green. I want to create one list box that will filter ONLY records of type A by color, and another that will filter only type B by color. So both list boxes will say red, yellow, and green, but when I select Red on list box A, it will filter those records of type A, but records of type B will remain in tact. Then, I can select Green in list box B, and it will filter records of type B, but leave type A in tact. So the resulting data set will be one table with records of Type A with color Red and records of type B with color Green. This is easy to do if I have 2 separate tables, but is it possible to do with one? Thanks for the help!

[manishkumar75]

Hi,

Please see the attached application. I am not sure , whether this will match with ur requirement.

- Manish

[ali_hijazi]

As I understood you want to select values from a listbox using code or macro!

if you click on Settings->Document properties then select Triggers tab there you can find something called field trigger from there you can add a macro and put a condition on what to select from another listbox

I attached a sample document and hope it helps

[sebastiandperei]

Hi t_eweiss,

It's really difficult to understand for me (from Argentina), but if i do it right, you have to create a calculated dimmention in each listbox:

=If(Left(Type&Colour,1)='A',Colour)

But...  This wil select, for the Type A, only the Colour you select on the ListBox, but it will exclude all other Types.

Then, you must to create 3 auxiliar unlinked tables. Like TypeA_Colour, TypeB_Colour and TypeC_Colour tables, with A_Colour, B_Colour and C_Colour field each one.Then the expression would be:

=Sum ({$<Colour={=$(Concat(A_Colour,', '))}, Type={A}>} +

Sum ({$<Colour={=$(Concat(B_Colour,', '))}, Type={B}>} +

Sum ({$<Colour={=$(Concat(C_Colour,', '))}, Type={C}>}

This way, each Sum will filter, only for their Type, the field Color you have selected in its listbox.

Sorry for my poor english!!

Sebas

[sebastiandperei]

Does it helps you?