Redirect to another sheet based on selecting a field in qlikview

[shamitshah]

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

[shwethaa]

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 · Accepted solution]

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

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

[shwethaa]

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]

Thanks!

[shamitshah]

Hi Shwetha,

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

Or

Field -> DimensionB

Search String -> GetSelectedCount(DimensionB)>=1