topic Re: Metric with filter in QlikView https://community.qlik.com/t5/QlikView/Metric-with-filter/m-p/789143#M279036 <HTML><HEAD></HEAD><BODY><P>Hi, not sure to understand the requirements, you want a expression like:</P><P>Sum(TOTAL {&lt;Country={'US'}&gt;} Sales)/Sum(TOTAL Sales)</P></BODY></HTML> Thu, 20 Nov 2014 15:04:59 GMT rubenmarin 2014-11-20T15:04:59Z Metric with filter https://community.qlik.com/t5/QlikView/Metric-with-filter/m-p/789142#M279035 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I want to show a value in % that will describe how much of sales is in US vs. all countries. This is just an example scenario. </P><P>Please see grid below. Country and Sales are column names taken from warehouse. </P><P></P><P>Country&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sales</P><P> US&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,000,000<BR /> Canada&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5,000<BR /> Germany&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6,500<BR /> China&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12,000</P><P></P><P>Metric that I want to build is an expression:&nbsp; <STRONG>SUM (Sales) </STRONG>where<STRONG> {Country = US} / SUM (Sales)</STRONG>(Sales for all countries)<STRONG>. </STRONG>Can you<STRONG> </STRONG>please paste me the script that I need to put in my expresion in grid? I am still using free version of QlikView so I can’t really open any example made in this tool. </P><P></P><P>Thanks!</P></BODY></HTML> Thu, 20 Nov 2014 14:56:32 GMT https://community.qlik.com/t5/QlikView/Metric-with-filter/m-p/789142#M279035 2014-11-20T14:56:32Z Re: Metric with filter https://community.qlik.com/t5/QlikView/Metric-with-filter/m-p/789143#M279036 <HTML><HEAD></HEAD><BODY><P>Hi, not sure to understand the requirements, you want a expression like:</P><P>Sum(TOTAL {&lt;Country={'US'}&gt;} Sales)/Sum(TOTAL Sales)</P></BODY></HTML> Thu, 20 Nov 2014 15:04:59 GMT https://community.qlik.com/t5/QlikView/Metric-with-filter/m-p/789143#M279036 rubenmarin 2014-11-20T15:04:59Z