How to change the value dynamically whenever select a category

Sat, 24 May 2014 07:24:10 GMT

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

Re: How to change the value dynamically whenever select a category

swuehl — Sat, 24 May 2014 09:17:46 GMT

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.

topic How to change the value dynamically whenever select a category in QlikView

How to change the value dynamically whenever select a category

Re: How to change the value dynamically whenever select a category