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

dmohanty — Mon, 27 Jul 2015 18:17:48 GMT

Hi All,

Helping you in detailing about the requirement. Let's say I have a data set like this below:

USER_ID	Document	Bookmark_ID	BookmarkFieldName	BookmarkFieldValue
JOHN_SMITH	Dashboard	BM01-51	$Account Fields	Account #, Account Name, Account Address, Phone, ZIP
JOHN_SMITH	Dashboard	BM01-51	$KEY	1
JOHN_SMITH	Dashboard	BM01-51	Account Name	Pharma
JOHN_SMITH	Dashboard	BM01-51	Historical Availability	Available
JOHN_SMITH	Dashboard	BM01-51	Previous Month	Active

Requirement:

The User = JOHN_SMITH, will select Document = Dashboard and Bookmark_ID = BM01-51 from the List Boxes.
The corresponding records from the field BookmarkFieldName and BookmarkFieldValue are got displayed, like above result.
Now I will have an APPLY Button, upon Clicking which the Values displayed in the BookmarkFieldValue will be applied/selected as values for the respective list boxes.
Example here - $Account Fields , $KEY,Account Name,Historical Availability,Previous Month will be treated as List Boxes/Select in Fields and their corresponding values - "Account #, Account Name, Account Address, Phone, ZIP" , "1" , "Pharma" , "Available" , "Active" will be selected in the QlikView Document.

Can someone please help here?

Regards!!!

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