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: 
Not applicable

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

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!

4 Replies
manishkumar75
Partner
Partner

Hi,

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

- Manish

ali_hijazi
Partner
Partner

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

I can walk on water when it freezes
sebastiandperei
Specialist
Specialist

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

Does it helps you?