topic linking a list box selections with table values in QlikView

linking a list box selections with table values

Mon, 19 Jul 2010 11:25:06 GMT

hi, is there is a way of linking a newly created list box (that has a list of Aged Groups) with a table.

If a list box category is selected then it should filter the table based on that value selected.

I want to do this without creating any relationships with tables in the load script.

The list box 'Aged Group' category should be liked to the a field in the table 'Aged Days Group'. The field 'Aged Days Group' is a calcaulated expression in the table. The following is the expression:

--------------

=IF([Days Outstanding]<30,'Under 30 Days',IF([Days Outstanding]>=30 AND [Days Outstanding]<60,'30-60 Days',IF([Days Outstanding]>=60 AND [Days Outstanding]<90,'60-90 Days',IF([Days Outstanding]>=90 AND [Days Outstanding]<180,'90-180 Days', IF([Days Outstanding]>=180,'180+ Days','no date')))))

-------------

linking a list box selections with table values

Mon, 19 Jul 2010 17:04:35 GMT

Hi, I am not sure I fully understand your query but you can reference a table to a list box without creating a link while loading the data by creating a variable (settings - variable overview - add) and call it age_selected

In the definition write = [Aged goup] - or whatever the field is called in the list box

build your expression around this variable....

linking a list box selections with table values

Mon, 19 Jul 2010 18:06:32 GMT

Hi, the data table is already created, the 'Days Outstanding' field is calculated from the 'Date' field and the 'Aged Days Group' is calculated by the IF statement.

I already know what the list box values should be and just want it to filter the table data.

Im not sure if the method you proposed allows this as the definition of aged group is already defined.

I know how to create list boxes and use these to filter the data but only when table relationships are created. The problem with this is that the field 'Aged days Group' is a calculated expression.

Is this any clearer?