topic expression based on dimension in QlikView https://community.qlik.com/t5/QlikView/expression-based-on-dimension/m-p/1460467#M795146 <HTML><HEAD></HEAD><BODY><P>Can I calculate the expression depending on the Dimension value.</P><P>For example is the Country is US I want the sum but if Others I want empty:</P><P>So from :</P><P><IMG alt="2018-01-08_09-48-31.bmp" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/189275_2018-01-08_09-48-31.bmp" style="height: auto;" /></P><P>to </P><P><IMG alt="2018-01-08_11-41-08.bmp" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/189277_2018-01-08_11-41-08.bmp" style="height: auto;" /></P><P></P><P>Many thanks,</P><P>Raphael</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z expression based on dimension https://community.qlik.com/t5/QlikView/expression-based-on-dimension/m-p/1460467#M795146 <HTML><HEAD></HEAD><BODY><P>Can I calculate the expression depending on the Dimension value.</P><P>For example is the Country is US I want the sum but if Others I want empty:</P><P>So from :</P><P><IMG alt="2018-01-08_09-48-31.bmp" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/189275_2018-01-08_09-48-31.bmp" style="height: auto;" /></P><P>to </P><P><IMG alt="2018-01-08_11-41-08.bmp" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/189277_2018-01-08_11-41-08.bmp" style="height: auto;" /></P><P></P><P>Many thanks,</P><P>Raphael</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/expression-based-on-dimension/m-p/1460467#M795146 Anonymous 2020-11-25T16:16:04Z Re: expression based on dimension https://community.qlik.com/t5/QlikView/expression-based-on-dimension/m-p/1460468#M795147 <HTML><HEAD></HEAD><BODY><P>Hi Raphael, in this sample can work with this expression:</P><P>If(Country = 'US', sum(Score), '')</P></BODY></HTML> Mon, 08 Jan 2018 11:47:27 GMT https://community.qlik.com/t5/QlikView/expression-based-on-dimension/m-p/1460468#M795147 rubenmarin 2018-01-08T11:47:27Z Re: expression based on dimension https://community.qlik.com/t5/QlikView/expression-based-on-dimension/m-p/1460469#M795148 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><STRONG>=If(Country = 'US', Sum(Score), '')</STRONG></P></BODY></HTML> Mon, 08 Jan 2018 11:47:40 GMT https://community.qlik.com/t5/QlikView/expression-based-on-dimension/m-p/1460469#M795148 Anil_Babu_Samineni 2018-01-08T11:47:40Z