How to change the value dynamically whenever select a category

[#1]

Hi Experts,

I am new to Qlikview and I would like to know how to change the values dynamically when select the List values:

Data like this:

Current_Category:

Question ID     description   response

112                    ABC               1

113                    XYZ               2

Saving_Category:

Question ID     description     response

115                    ABC               5

118                    XYZ                6

Here Question ID is different,but description is same, so user want to select the Current OR Saving then it will pick the Question ID then it will display the corresponding response values

List box like this

Category

Current_category

Saving_category

when we will select on current category or saving category then it will hit to the Question ID and need to display that Response values

Thanks in Advance

[swuehl]

If I understood correctly, you should be fine with concatenating your tables:

YourData:

LOAD [Question ID], description, response, 'Current' as Category FROM Current_Category;

//following table will be auto-concatenated because of same field names

LOAD [Question ID], description, response, 'Saving' as Category FROM Saving_Category;

Then create list boxes for description, [question ID] and response. Selecting in your described order should show work as intended (as far as I understood).

You can additionally display the new Category list box if needed.