topic Can I drilldown expressions? in QlikView https://community.qlik.com/t5/QlikView/Can-I-drilldown-expressions/m-p/764667#M271800 <HTML><HEAD></HEAD><BODY><P>Hi, I have a straight table with following dims and expressions:</P><P></P><P>Dims: Project, Priority</P><P>Expression: Breach</P><P></P><P>eg:</P><P>Project&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Priority&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Breach</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Severity1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Severity2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Severity3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</P><P style="font-size: 13.3333330154419px;">B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Severity1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P style="font-size: 13.3333330154419px;">B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Severity2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P style="font-size: 13.3333330154419px;">B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Severity3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P></P><P> The <SPAN style="font-size: 13.3333330154419px;">expression "Breach" is calculated as below:</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; count(if(upper([Response SLA])='MISS', Key))</P><P>Note: Key and [Response SLA] are 2 fields from the source.</P><P></P><P>My requirement is to see all Keys(in a table box) when any "Breach" cell is selected in the above chart. The issue I am facing is I am not able to drill down on the "Breach" field - when I select any cell on Breach field, it gives me all Keys for that specific Project and Priority(i.e the "Total" field)</P><P></P><P></P><P>Thanks</P><P>Sam</P></BODY></HTML> Fri, 20 Feb 2015 18:11:32 GMT Anonymous 2015-02-20T18:11:32Z Can I drilldown expressions? https://community.qlik.com/t5/QlikView/Can-I-drilldown-expressions/m-p/764667#M271800 <HTML><HEAD></HEAD><BODY><P>Hi, I have a straight table with following dims and expressions:</P><P></P><P>Dims: Project, Priority</P><P>Expression: Breach</P><P></P><P>eg:</P><P>Project&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Priority&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Breach</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Severity1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Severity2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Severity3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</P><P style="font-size: 13.3333330154419px;">B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Severity1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P style="font-size: 13.3333330154419px;">B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Severity2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P style="font-size: 13.3333330154419px;">B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Severity3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P></P><P> The <SPAN style="font-size: 13.3333330154419px;">expression "Breach" is calculated as below:</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; count(if(upper([Response SLA])='MISS', Key))</P><P>Note: Key and [Response SLA] are 2 fields from the source.</P><P></P><P>My requirement is to see all Keys(in a table box) when any "Breach" cell is selected in the above chart. The issue I am facing is I am not able to drill down on the "Breach" field - when I select any cell on Breach field, it gives me all Keys for that specific Project and Priority(i.e the "Total" field)</P><P></P><P></P><P>Thanks</P><P>Sam</P></BODY></HTML> Fri, 20 Feb 2015 18:11:32 GMT https://community.qlik.com/t5/QlikView/Can-I-drilldown-expressions/m-p/764667#M271800 Anonymous 2015-02-20T18:11:32Z Re: Can I drilldown expressions? https://community.qlik.com/t5/QlikView/Can-I-drilldown-expressions/m-p/764668#M271801 <HTML><HEAD></HEAD><BODY><P>can you provide source or sample data?</P></BODY></HTML> Sat, 21 Feb 2015 11:13:26 GMT https://community.qlik.com/t5/QlikView/Can-I-drilldown-expressions/m-p/764668#M271801 MK_QSL 2015-02-21T11:13:26Z Re: Can I drilldown expressions? https://community.qlik.com/t5/QlikView/Can-I-drilldown-expressions/m-p/764669#M271802 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Drilling on expression is not supported.</P><P></P><P>Regards</P><P>ASHFAQ</P><DIV style="display: none;"> </DIV><DIV style="display: none;"> </DIV><DIV style="display: none;"> </DIV></BODY></HTML> Sun, 22 Feb 2015 01:52:51 GMT https://community.qlik.com/t5/QlikView/Can-I-drilldown-expressions/m-p/764669#M271802 ashfaq_haseeb 2015-02-22T01:52:51Z