topic Action- 'Select in Field' to be Dynamic and Recursive in QlikView

Action- 'Select in Field' to be Dynamic and Recursive

dmohanty — Mon, 27 Jul 2015 04:18:34 GMT

Hi All,

I am having a data set like this below. I need to Create Action on a Button using 'Select Field'.

ID	Country	Group	Stuff
100	USA	Footwear	Boots,Sandals,Bellies,Canvas
200	CAN	Cereals	Rice,Wheat,Maize

Requirement:

The user will choose a value from the List Box: ID, let say value 100.
Then the corresponding value from Group = 'Footwear' will be used as 'Select in Field' and the values 'Boots,Sandals,Bellies,Canvas' will be used as 'Search String' in the Action of the Button.
Similarly when ID = 200 is selected the Action changes to Select in Field = Cereals and the Search String = Rice,Wheat,Maize.

Can the Select in Fields be made dynamic like above scenario? Please help and guide!

sushil353 — Mon, 27 Jul 2015 04:56:30 GMT

hi,

If you have 1 to 1 relation then you can use MaxString(stuff) to get the values from other field based on your selection

svenkita — Mon, 27 Jul 2015 05:02:11 GMT

create a drill down group and have the fields Group and Stuff

create a list box

attaching the sample

hope this helps

dmohanty — Mon, 27 Jul 2015 12:34:37 GMT

Hi Venkita,

Thank you for the help.

How can I use the Possible Values in the Stuff list box to be used as a Search String in Action of a Button?

Any suggestions?

rwunderlich — Mon, 27 Jul 2015 18:42:50 GMT

Are "Cereals" and "Footwear" field names, or field values?

-Rob