NAVIGATION

[karthikchintu30]

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

[boorgura]

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"

[vishsaggi]

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.

[karthikchintu30]

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.

[karthikchintu30]

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.

[vishsaggi]

Check this attached?

[karthikchintu30]

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

[vishsaggi]

Did you check attached? Is it not what you are expecting?

[karthikchintu30]

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.

[vishsaggi]

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?