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!!!