topic Re: Dimension Link to A Different Sheet with a different field selection in QlikView

Dimension Link to A Different Sheet with a different field selection

cbaqir — Thu, 17 Dec 2015 18:20:39 GMT

Okay, here is part two to https://community.qlik.com/message/936446?et=watches.email.thread#936446

Requirements:

When a user selects a REQUEST_ID_LKUP, display all other REQUEST_IDs that share the same Activity Code. - COMPLETED
When a user selects a different REQUEST_ID_LKUP from the table displayed from Requirement 1, jump to Project Details sheet and show information for selected REQUEST_ID.
1. The Project Details sheet shows a table without Dimension and with an expression of only(FIELD). How can this table show the details for the newly selected Request?

Example:

Finances sheet:

User wants to see all associated financial data with REQ_ID 171440.
1. User enters 171440 in the Search Box and selects the REQUEST_ID_LKUP for 171440
2. Table with Set Analysis displays all other REQUEST_ID_LKUP that share the same ACTIVITY_CODE as 171440.
User wants to see financial details associated with one of the other REQUEST_ID_LKUP.
1. User clicks on 59166 in the Table with Set Analysis.
  1. DESIRED: Project Details sheet opens with 59166 as REQ_ID (NOT REQUEST_ID_LKUP) and displays related information for 59166.

How do I correctly set my Document Triggers to only open the Project Details tab and show the Request information related from REQUEST_ID as opposed to REQUEST_ID_LKUP?

To work with the other tabs in the dashboard, generally information is displayed for a REQ_ID selection.

Re: Dimension Link to A Different Sheet with a different field selection

Gysbert_Wassenaar — Thu, 17 Dec 2015 18:58:53 GMT

1. You can use an set analysis expression like sum({<REQUEST_ID_LKUP=P({<ACTIVITY_CODE=P(ACTIVITY_CODE)}>}REQUEST_ID_LKUP)>} Value)

2. That requires magic. Assign an Activate Sheet action to the OnSelect field trigger of the REQUESTI_ID_LKUP field. But a table without dimensions will only show only line with the results of the expressions. That doesn't sound like a details table to me. So, I probably don't understand what you mean.

Re: Dimension Link to A Different Sheet with a different field selection

cbaqir — Thu, 17 Dec 2015 19:52:16 GMT

Thanks for the response. Did you see my sample? Requirement #1 is working using =only({1<ACTIVITY_CODE=p(ACTIVITY_CODE)>}ACTIVITY_CODE) .