Click on a field and navigate to another sheet

[#1]

Hi,

Now I have begun to work with Qlikview and try to learn it in more depth. This is my question:

I would like to create a report with a simple table and to list documents in one of the columns (the id of the document would be stored in this column). The other columns have information about creation date, owner and other properties of each document.

The simple table would be in a sheet. Then I'd want to click on an id of document and navigate to another sheet where the details of the selected document would appear.

How can I do that? Is there any document about this?

Thanks in advance.

Lucía

[simospa]

Hi Lucia,

you could see the sample I attached to this thread and follow these steps:

1. create a table, I estabilished that field "id" is the one you want to use to change sheet;

2. go to Settings --> Documento Properties --> Triggers --> Field Event Triggers select the "id" field, then click on button Add Action(s) under OnSelect option;

3. choose Action Type = Layout and Action = Activate Sheet;

4. In field Sheet ID enter ='SH' & id then click to ok.

5. Create as many sheets as row you are expecting

6. in Sheet Properties ensure that the Sheet ID is like you are expected: if your documents id are 1, 2, 3, 4, etc... you must change the default name from SH01, SH02, SH03 to SH1, SH2, SH3.

This solution has a limit due to the number of sheets that you have to create (you must know that you are loading exactly n rows, and all the id). This can be a problem. I don't want what you are searching to do, but consider to use a single page with an object (char, table) that can change your data with the selection you do.

Let me know.

S.

[beck_bakytbek]

Hi Lucia,

there is in www an interesting contribution to this issue:

www.youtube.com/watch?v=fRuN1AGMV0E

i hope this helps

Beck

[Anonymous]

Hi,

Can you suggest any solution in Qlik Sense.

[Anil_Babu_Samineni]

@santhosh - if you can use vizlib table you can see the feature.