Re: Action- 'Select in Field' to be Dynamic and Recursive
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.
