topic Expression on row in QlikView https://community.qlik.com/t5/QlikView/Expression-on-row/m-p/118200#M509071 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #0000ff; font-size: 8pt;">How can I get the expression to show on the second row with the resource of nbush instead of the core_builder?</SPAN></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><IMG alt="2018-10-18_10-25-27.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/216263_2018-10-18_10-25-27.jpg" style="width: 620px; height: 121px;" /></SPAN></P><P></P><P></P><P></P><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">max</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">FACT_ALM_DEFECT_RESOURCE.START_DATE</SPAN><SPAN style="font-size: 8pt;">)-<BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">min</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">FACT_ALM_DEFECT_RESOURCE.START_DATE</SPAN><SPAN style="font-size: 8pt;">),</SPAN><SPAN style="color: #800000; font-size: 8pt;">DEFECT_ID</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">[FACT_ALM_DEFECT_RESOURCE.RESOURCE TYPE]</SPAN><SPAN style="font-size: 8pt;">))<BR /> /</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">DISTINCT</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">DEFECT_ID</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P></BODY></HTML> Thu, 18 Oct 2018 17:27:20 GMT cbaqir 2018-10-18T17:27:20Z Expression on row https://community.qlik.com/t5/QlikView/Expression-on-row/m-p/118200#M509071 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #0000ff; font-size: 8pt;">How can I get the expression to show on the second row with the resource of nbush instead of the core_builder?</SPAN></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><IMG alt="2018-10-18_10-25-27.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/216263_2018-10-18_10-25-27.jpg" style="width: 620px; height: 121px;" /></SPAN></P><P></P><P></P><P></P><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">max</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">FACT_ALM_DEFECT_RESOURCE.START_DATE</SPAN><SPAN style="font-size: 8pt;">)-<BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">min</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">FACT_ALM_DEFECT_RESOURCE.START_DATE</SPAN><SPAN style="font-size: 8pt;">),</SPAN><SPAN style="color: #800000; font-size: 8pt;">DEFECT_ID</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">[FACT_ALM_DEFECT_RESOURCE.RESOURCE TYPE]</SPAN><SPAN style="font-size: 8pt;">))<BR /> /</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">DISTINCT</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">DEFECT_ID</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P></BODY></HTML> Thu, 18 Oct 2018 17:27:20 GMT https://community.qlik.com/t5/QlikView/Expression-on-row/m-p/118200#M509071 cbaqir 2018-10-18T17:27:20Z