https://community.qlik.com/t5/App-Development/Metric-based-on-row-value-of-a-table/m-p/1860920#M71042 <P>Hello</P> <P>I have the following table</P> <P>CAR &nbsp; &nbsp;- &nbsp; &nbsp; MODEL &nbsp; &nbsp; - &nbsp; COUNTRY</P> <P>Audi - A4 - Spain<BR />Seat - Ibiza - England<BR />...</P> <P>I want a new column with the total cars selled, based in the country of each row.</P> <P>I tried this expression and works:&nbsp;Pick(1,MODEL)<BR />The expression returns the model for each row of the table.<BR /><BR />But if I try this expression, doesn't work:<BR />COUNT(TOTAL DISTINCT {&lt;MODEL={'$(=Pick(1,MODEL))'}&gt;} [Id Ad])</P> <P>How can I calculate a metric based on the value it has in each line of the table?</P> <P>Thank you so much.</P> Thu, 18 Nov 2021 11:19:17 GMT danielgarciamej 2021-11-18T11:19:17Z https://community.qlik.com/t5/App-Development/Metric-based-on-row-value-of-a-table/m-p/1860920#M71042 <P>Hello</P> <P>I have the following table</P> <P>CAR &nbsp; &nbsp;- &nbsp; &nbsp; MODEL &nbsp; &nbsp; - &nbsp; COUNTRY</P> <P>Audi - A4 - Spain<BR />Seat - Ibiza - England<BR />...</P> <P>I want a new column with the total cars selled, based in the country of each row.</P> <P>I tried this expression and works:&nbsp;Pick(1,MODEL)<BR />The expression returns the model for each row of the table.<BR /><BR />But if I try this expression, doesn't work:<BR />COUNT(TOTAL DISTINCT {&lt;MODEL={'$(=Pick(1,MODEL))'}&gt;} [Id Ad])</P> <P>How can I calculate a metric based on the value it has in each line of the table?</P> <P>Thank you so much.</P> Thu, 18 Nov 2021 11:19:17 GMT https://community.qlik.com/t5/App-Development/Metric-based-on-row-value-of-a-table/m-p/1860920#M71042 danielgarciamej 2021-11-18T11:19:17Z