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
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?
Check this?
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)
column order - (productid ,productname,sum(quantityperunit)) or (productname,productid,sum(quantityperunit))