topic Re: Need assistance with drilldown functionality in QlikView https://community.qlik.com/t5/QlikView/Need-assistance-with-drilldown-functionality/m-p/1321114#M845252 <HTML><HEAD></HEAD><BODY><P>I am implementing a similiar logic in QlikSense and i have the same problem, I need to drill down in an expression, to show the details for a sum of values, Have you found a solution for this problem?</P></BODY></HTML> Tue, 30 Jan 2018 14:46:38 GMT mariadiez 2018-01-30T14:46:38Z Need assistance with drilldown functionality https://community.qlik.com/t5/QlikView/Need-assistance-with-drilldown-functionality/m-p/1321112#M845250 <HTML><HEAD></HEAD><BODY><P>Hello!&nbsp; I'm new to QV and I know just enough to be dangerous.&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P>We have a need for a drilldown on our dashboard, and I just can't seem to get it to work.</P><P></P><P>Detailed data is:</P><P><SPAN style="font-size: 10pt;">Product unit ID (i.e.&nbsp; 12345)</SPAN></P><P>Product Description (i.e. Super Supreme Scooter Jr.)</P><P>Product Category (Scooters)</P><P>Product Category Status (Shipped)</P><P>Metric A (Something to measure)</P><P>Metric B <SPAN style="font-size: 13.3333px;">(Something to measure)</SPAN></P><P></P><P>I want to create a dashboard where I show the aggregated metrics, but also give the user the functionality to click on the <EM>aggregated metric</EM> <EM>cell</EM> and then be taken to a table that shows all the details for that particular dimension/metric.</P><P></P><P>In other words,</P><P>The aggregated metrics table would look like this.&nbsp; It is the first thing the users see, and we want them to be able to click on any <EM>SUM(METRIC X)</EM> column to be shown all the items relevant to that dimension/metric.</P><P><SPAN style="font-size: 10pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><TABLE border="1" class="jiveBorder" height="167.4" style="border: 1px solid #000000; width: 637.4px; height: 166.4px;" width="635.4"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Product Category</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Product Category Status </STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Metric A</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Metric B </STRONG></TH></TR><TR><TD style="padding: 2px;">Bikes</TD><TD style="padding: 2px;">Manufacture Complete</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">30</TD></TR><TR><TD style="padding: 2px;">Bikes</TD><TD style="padding: 2px;">Prep for Shipment</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">22</TD></TR><TR><TD style="padding: 2px;">Bikes</TD><TD style="padding: 2px;">Shipped</TD><TD style="padding: 2px;">30</TD><TD style="padding: 2px;">12</TD></TR><TR><TD style="padding: 2px;">Scooters</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Manufacture Complete</SPAN></TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">20</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Scooters</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Prep for Shipment</SPAN></TD><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">30</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Scooters</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Shipped</SPAN></TD><TD style="padding: 2px;">400</TD><TD style="padding: 2px;">100</TD></TR></TBODY></TABLE><P></P><P></P><P>After a user clicks <SPAN style="text-decoration: underline;">Metric A/ Bikes/Prep for Shipment</SPAN> I want them to see this:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><SPAN style="font-size: 13.3333px;">Product unit ID</SPAN></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><SPAN style="font-size: 13.3333px;">Product Description</SPAN></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><SPAN style="font-size: 13.3333px;">Product Category</SPAN></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><SPAN style="font-size: 13.3333px;">Product Category Status</SPAN></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><SPAN style="font-size: 13.3333px;">Metric A</SPAN></TH></TR><TR><TD style="padding: 2px;">12345</TD><TD style="padding: 2px;">Big Bubba Bike</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Bikes</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Prep for Shipment</SPAN></TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">23456</TD><TD style="padding: 2px;">Small Kid Bike</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Bikes</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Prep for Shipment</SPAN></TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">23456</TD><TD style="padding: 2px;">Old Folks Bile</TD><TD style="padding: 2px;">Bikes</TD><TD style="padding: 2px;">Prep for Shipment</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">etc</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P></P><P>Any insights would be greatly appreciated!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Need-assistance-with-drilldown-functionality/m-p/1321112#M845250 2020-11-25T16:16:04Z Re: Need assistance with drilldown functionality https://community.qlik.com/t5/QlikView/Need-assistance-with-drilldown-functionality/m-p/1321113#M845251 <HTML><HEAD></HEAD><BODY><P>Can you upload a set of data or an qvw for help you?</P></BODY></HTML> Sat, 01 Apr 2017 05:59:45 GMT https://community.qlik.com/t5/QlikView/Need-assistance-with-drilldown-functionality/m-p/1321113#M845251 ecolomer 2017-04-01T05:59:45Z Re: Need assistance with drilldown functionality https://community.qlik.com/t5/QlikView/Need-assistance-with-drilldown-functionality/m-p/1321114#M845252 <HTML><HEAD></HEAD><BODY><P>I am implementing a similiar logic in QlikSense and i have the same problem, I need to drill down in an expression, to show the details for a sum of values, Have you found a solution for this problem?</P></BODY></HTML> Tue, 30 Jan 2018 14:46:38 GMT https://community.qlik.com/t5/QlikView/Need-assistance-with-drilldown-functionality/m-p/1321114#M845252 mariadiez 2018-01-30T14:46:38Z