Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
shamitshah
Partner - Creator
Partner - Creator

Redirect to another sheet based on selecting a field in qlikview

Hi,

How can I  move between sheets based on selecting a field.

For example, I have three tabs 1) Main , 2) Detail and 3) Project Detail

Main

I have a table with Dimension A and Dimension B ( a summary table)

Detail

I have a table with Dimension A and Dimension B (a detailed table)

Project Detail

Table with Dimension A , Dimension B, Dimension Project (detail with projects)

If I select a field in Dimension B in the Main tab, it should take me to the Detail tab, then if I click on a Dimension B field in the Detail tab, it should take to the Project Detail tab.

Thanks

1 Solution

Accepted Solutions
andrey_krylov
Specialist
Specialist

I think you can try to set trigger for these fields.

Document Properties -> Triggers -> Field Event Triggter -> OnSelect     and there  Layout ->  Activate Sheet

View solution in original post

5 Replies
shwethaa
Contributor III
Contributor III

Set a trigger and action sheet trigger in sheet property, if getselectedcount(Dimension B)>=1 then active sheet (sheet ID Of detail tab), same way set this trigger even in detail  sheet.

andrey_krylov
Specialist
Specialist

I think you can try to set trigger for these fields.

Document Properties -> Triggers -> Field Event Triggter -> OnSelect     and there  Layout ->  Activate Sheet

shwethaa
Contributor III
Contributor III

I don't think so this works for above requirement. Same dimension is used to trigger from main to detail tab  and detail tab to project tab.

So if we create field event trigger, when users are in detail tab and they click on Dimension B , it will activate same sheet.

shamitshah
Partner - Creator
Partner - Creator
Author

Thanks!

shamitshah
Partner - Creator
Partner - Creator
Author

Hi Shwetha,

Do you insert GetSelectedCount(DimensionB)>=1 in Field?

Or

Field -> DimensionB

Search String -> GetSelectedCount(DimensionB)>=1