topic Re: Count a Field in QlikView https://community.qlik.com/t5/QlikView/Count-a-Field/m-p/126011#M765443 <HTML><HEAD></HEAD><BODY><P>Thank you so much, it hepls <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 12 Jul 2018 01:58:29 GMT rmdnkevin 2018-07-12T01:58:29Z Count a Field https://community.qlik.com/t5/QlikView/Count-a-Field/m-p/126007#M765439 <HTML><HEAD></HEAD><BODY><P>Hi, everyone.</P><P></P><P>I have this kind of table :</P><P><IMG alt="Screenshot_3.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/207415_Screenshot_3.png" style="height: auto;" /></P><P>I want to make a text object that only count each sum, such Travel = 3798, Shop = 278, etc.</P><P></P><P>How can I count that in an expression ?</P><P></P><P>Thank you</P><P>-Kevin</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Count-a-Field/m-p/126007#M765439 rmdnkevin 2020-11-25T16:16:04Z Re: Count a Field https://community.qlik.com/t5/QlikView/Count-a-Field/m-p/126008#M765440 <HTML><HEAD></HEAD><BODY><P>Why not a straight table instead of a text box?</P></BODY></HTML> Tue, 10 Jul 2018 07:30:10 GMT https://community.qlik.com/t5/QlikView/Count-a-Field/m-p/126008#M765440 dapostolopoylos 2018-07-10T07:30:10Z Re: Count a Field https://community.qlik.com/t5/QlikView/Count-a-Field/m-p/126009#M765441 <HTML><HEAD></HEAD><BODY><P>You can use set analysis</P><P>sum( {&lt;Requirement={'Travel'}&gt;} USD)</P></BODY></HTML> Tue, 10 Jul 2018 07:47:19 GMT https://community.qlik.com/t5/QlikView/Count-a-Field/m-p/126009#M765441 pooja_prabhu_n 2018-07-10T07:47:19Z Re: Count a Field https://community.qlik.com/t5/QlikView/Count-a-Field/m-p/126010#M765442 <HTML><HEAD></HEAD><BODY><P>Hi, try in text box with :</P><P></P><P>='Requirement=Travel'&amp;sum( {&lt;Requirement={'Travel'}&gt;} USD)&amp;chr(10)&amp;'Requirement=Shop'&amp;sum( {&lt;Requirement={'Shop'}&gt;} USD)&amp;chr(10)&amp;'Requirement=Education'&amp;sum( {&lt;Requirement={'Education'}&gt;} USD)</P></BODY></HTML> Tue, 10 Jul 2018 07:50:30 GMT https://community.qlik.com/t5/QlikView/Count-a-Field/m-p/126010#M765442 sergio0592 2018-07-10T07:50:30Z Re: Count a Field https://community.qlik.com/t5/QlikView/Count-a-Field/m-p/126011#M765443 <HTML><HEAD></HEAD><BODY><P>Thank you so much, it hepls <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 12 Jul 2018 01:58:29 GMT https://community.qlik.com/t5/QlikView/Count-a-Field/m-p/126011#M765443 rmdnkevin 2018-07-12T01:58:29Z Re: Count a Field https://community.qlik.com/t5/QlikView/Count-a-Field/m-p/126012#M765448 <HTML><HEAD></HEAD><BODY><P>Thank you for your response, it's solved<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 12 Jul 2018 01:58:58 GMT https://community.qlik.com/t5/QlikView/Count-a-Field/m-p/126012#M765448 rmdnkevin 2018-07-12T01:58:58Z Re: Count a Field https://community.qlik.com/t5/QlikView/Count-a-Field/m-p/126013#M765451 <HTML><HEAD></HEAD><BODY><P>Thank you for your response, it's solved<SPAN class="emoticon-inline emoticon_happy" style="font-weight: inherit; font-style: inherit; font-family: inherit;"></SPAN><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 12 Jul 2018 01:59:15 GMT https://community.qlik.com/t5/QlikView/Count-a-Field/m-p/126013#M765451 rmdnkevin 2018-07-12T01:59:15Z