topic Re: Drilling down in QlikView https://community.qlik.com/t5/QlikView/Drilling-down/m-p/988578#M527871 <HTML><HEAD></HEAD><BODY><P>could you post your qvw scrambled version if possible.</P><P>which table contains Area, Facility and Dept ? do you have associated records for the date selected?</P></BODY></HTML> Fri, 02 Oct 2015 19:21:22 GMT sudeepkm 2015-10-02T19:21:22Z Drilling down https://community.qlik.com/t5/QlikView/Drilling-down/m-p/988577#M527870 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P><IMG alt="Scrap Chart.png" class="jive-image image-1" src="/legacyfs/online/100808_Scrap Chart.png" style="height: 241px; width: 620px;" /></P><P></P><P>I created the above Scrap Trend per Std Hrs by using the following equation:</P><P></P><P>(sum({$&lt;YEAR_NO={$(vCurrentYear)} &gt;} UNIT_COST*SCRAP_QTY))</P><P>/</P><P>(sum ({$&lt;YEAR_NO={$(vCurrentYear)} &gt;} TOTAL_HOURS))</P><P></P><P>and I have a variable called vPriorYear for 2014 and did the same for that.&nbsp; UNIT_COST AND SCRAP_QTY come from the SCRAP table and TOTAL_HOURS comes from the STDHRS table as shown below.</P><P></P><P><IMG alt="tables.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/100809_tables.png" style="height: auto;" /></P><P></P><P></P><P>When I try to filter the data by Area, Facility, or department, the chart shows 'No data to display', as shown below.&nbsp; Does anyone know how to fix this?</P><P></P><P></P><P><IMG alt="no data.png" class="jive-image image-3" src="/legacyfs/online/100810_no data.png" style="height: 315px; width: 620px;" /></P></BODY></HTML> Fri, 02 Oct 2015 17:32:54 GMT https://community.qlik.com/t5/QlikView/Drilling-down/m-p/988577#M527870 2015-10-02T17:32:54Z Re: Drilling down https://community.qlik.com/t5/QlikView/Drilling-down/m-p/988578#M527871 <HTML><HEAD></HEAD><BODY><P>could you post your qvw scrambled version if possible.</P><P>which table contains Area, Facility and Dept ? do you have associated records for the date selected?</P></BODY></HTML> Fri, 02 Oct 2015 19:21:22 GMT https://community.qlik.com/t5/QlikView/Drilling-down/m-p/988578#M527871 sudeepkm 2015-10-02T19:21:22Z Re: Drilling down https://community.qlik.com/t5/QlikView/Drilling-down/m-p/988579#M527872 <HTML><HEAD></HEAD><BODY><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/100813_Untitled.png" style="height: 349px; width: 620px;" /></P></BODY></HTML> Fri, 02 Oct 2015 19:37:53 GMT https://community.qlik.com/t5/QlikView/Drilling-down/m-p/988579#M527872 2015-10-02T19:37:53Z