navigating to another sheet by clicking a value and data limitation

[UserID2626]

hi,

     I need to navigate from one sheet to another sheet when clicking on one value on first report it should take that value to the second report as a parameter and the details of the values present in second report should be displayed.

need results in qlik sense not in qlik view

[YoussefBelloum]

Hi,

for the 1st points, you will have to use extensions.

take a look at this one:

http://branch.qlik.com/?&_ga=2.246658823.281339963.1524641889-1209233014.1524641889#!/project/56728f...

[UserID2626]

in this extension navigation is done using Button

but i need to navigate by clicking a value for eg: a table contain emp_id, emp_name.if i am clicking any emp_id, the sheet should navigate to another sheet and need to display the details of the employee which selected

[YoussefBelloum · Accepted solution]

Yes I see what you're looking for.

out of the box, no way to do this.. so I tried to help with providing you an alternative.

in this extension, you have also the possibility to set a variable to the button, try to create a variable using this expression: GetSelectedCount(your_field)>0 and attach it to the button.. maybe the action of the button will start according to the value of this variable and it will allow you to move between sheets the way you want

[UserID2626]

thanks youssef

[YoussefBelloum]

you're welcome, try it and let me know, you can try it on a test app and attach it here if you're stuck, maybe I can take a look

[MyMagic]

I know a solution has been marked but I've found a straightforward one.

1. Use VizLib Table

2. Interactivity-> Unselect "Enable Multiselect"

3. Data-> Select the column where you want value selection to move to next sheet

4. Actions-> Add Action-> Activate Sheet