topic Re: NAVIGATION in QlikView

NAVIGATION

karthikchintu30 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: NAVIGATION

boorgura — Mon, 02 Apr 2018 15:27:14 GMT

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"

Re: NAVIGATION

vishsaggi — Mon, 02 Apr 2018 17:43:53 GMT

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.

Re: NAVIGATION

karthikchintu30 — Tue, 03 Apr 2018 05:47:19 GMT

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.

Re: NAVIGATION

karthikchintu30 — Tue, 03 Apr 2018 06:10:08 GMT

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.

Re: NAVIGATION

vishsaggi — Tue, 03 Apr 2018 17:37:33 GMT

Check this attached?

Re: NAVIGATION

karthikchintu30 — Wed, 04 Apr 2018 09:55:16 GMT

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

Re: NAVIGATION

vishsaggi — Wed, 04 Apr 2018 13:25:06 GMT

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

Re: NAVIGATION

karthikchintu30 — Wed, 04 Apr 2018 13:49:40 GMT

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.

Re: NAVIGATION

vishsaggi — Wed, 04 Apr 2018 15:59:54 GMT

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?

Re: NAVIGATION

vishsaggi — Wed, 04 Apr 2018 16:13:17 GMT

Can I know what exactly your trying to achieve or your user requirement is? Your sum(QuantityPerUnit) has values aggregated by ProductID and ProductName so when you click on one Quanity which has specific ProductID and ProductName will be selected. What is the usability of clicking on Sum(QuantityPerUnit) and get all ProductNames and ProductID. Why cant you just click on specific ProductID which is more straight forward?

Re: NAVIGATION

vishsaggi — Wed, 04 Apr 2018 17:22:34 GMT

Check this?

Re: NAVIGATION

karthikchintu30 — Wed, 16 May 2018 10:39:00 GMT

Hi Nagaraju,

Thanks for the response

It is like if i click on product id or name it should not transfer to next sheet,it should only transfer when i click on sum(quantityperunit) but in the above qvw it is transferring to sheet when i click on product name of particular

product id.

1.click on any product id

2.click on productname

In this scenario it is transferring to next sheet ,but it should not transfer

it should transfer only when i click on sum(quantityperunit) but not on productid or product name

my requirement is

1.when i keep columns in a particular order (productid ,productname,sum(quantityperunit)) or (productid,productname,sum(quantityperunit) and when i click on sum(quantityperunit),it should navigate to the next sheet and it should show me all the records of product id that is associated with that sum(quantityperunit)

Re: NAVIGATION

karthikchintu30 — Wed, 16 May 2018 11:08:44 GMT

column order - (productid ,productname,sum(quantityperunit)) or (productname,productid,sum(quantityperunit))