Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi qlikers,
I have a pivot table in a sheet in that iam having Productid,productname,Sum( Quantityperunit) and in the other sheet iam having Productid,productname,quantityperunit,unitcost.
Now my requirement is that if i click on any value in sum(quantityperunit) in the main sheet ,It should navigate to the next sheet and it should show the total values(productid,productname,quantityperunit,unitcost) associated with that particular value
Add a field event trigger on "Product Name" to activate next sheet.
go to Settings --> Document Properties --> Triggers --> Field Event Triggers --> ProductName --> "Add Actions" under "OnSelect".
Add --> Layout --> "Activate Next Sheet"
Check attached if this is what you are looking for?
Points to note. Reference to what Rakesh mentioned using Doc Prop triggers. Using Variable event triggers I have set some actions in Variable Event Trigger on Change. Look into it for what actions added.
Created a variable vProductNameSlct to get the selection in sheet 1. Click Ctrl+Alt+V to view the variable expr used.
Hi rakesh
Thanks for the response.
But the thing is that i want the action to be performed only when i click on sum(quantityperunit) it should not perform action on productid,productname.
Hi Nagaraju,
Thanks for the response.
I have gone through your QVW,But My requirement is that it should navigate only when i click on sum(quantityperunit) and it should not navigate when i click on productid or productname.
Thanks&Regards
Karthik.
Check this attached?
Hi nagaraju,
Thanks For the Response
Can I get all the 3records that are associated with particular product ID,If i click on any of sum(quantityperunit) value of a particular productid
Did you check attached? Is it not what you are expecting?
Hi nagaraju
yes i checked it,it is showing me the single record of the productid but i need all the records associated with the productid.
When you click on Sum(QuantityPerUnit) you are selecting only one row so for that row you will get only one product ID right? Am I missing something?