topic Re: expression for total selected values in QlikView https://community.qlik.com/t5/QlikView/expression-for-total-selected-values/m-p/1347728#M841133 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P><STRONG>Count({&lt;sales -= {'-',''}&gt;} sales)</STRONG></P><P></P></BODY></HTML> Tue, 02 May 2017 06:49:28 GMT Anil_Babu_Samineni 2017-05-02T06:49:28Z expression for total selected values https://community.qlik.com/t5/QlikView/expression-for-total-selected-values/m-p/1347727#M841132 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>Please find the below data ,</P><P>For this data i want the expression for it<SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';"> will tell how many Prdoucts have a value for this&nbsp; selected period.</SPAN></P><TABLE border="1" class="jiveBorder" height="249" style="border: 1px solid #000000; width: 413px; height: 189px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Year</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Product</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">sales</TH></TR><TR><TD style="padding: 2px;">2016</TD><TD style="padding: 2px;">a</TD><TD style="padding: 2px;">10</TD></TR><TR><TD style="padding: 2px;">2016</TD><TD style="padding: 2px;">b</TD><TD style="padding: 2px;">-</TD></TR><TR><TD style="padding: 2px;">2017</TD><TD style="padding: 2px;">a</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">2016</TD><TD style="padding: 2px;">b</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">2015</TD><TD style="padding: 2px;">a</TD><TD style="padding: 2px;">110</TD></TR><TR><TD style="padding: 2px;">2015</TD><TD style="padding: 2px;">b</TD><TD style="padding: 2px;">120</TD></TR><TR><TD style="padding: 2px;">2015</TD><TD style="padding: 2px;">c</TD><TD style="padding: 2px;">-</TD></TR><TR><TD style="padding: 2px;">2014</TD><TD style="padding: 2px;">c</TD><TD style="padding: 2px;">20</TD></TR><TR><TD style="padding: 2px;">2014</TD><TD style="padding: 2px;">a</TD><TD style="padding: 2px;">-</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/expression-for-total-selected-values/m-p/1347727#M841132 prabhas277 2020-11-25T16:16:04Z Re: expression for total selected values https://community.qlik.com/t5/QlikView/expression-for-total-selected-values/m-p/1347728#M841133 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P><STRONG>Count({&lt;sales -= {'-',''}&gt;} sales)</STRONG></P><P></P></BODY></HTML> Tue, 02 May 2017 06:49:28 GMT https://community.qlik.com/t5/QlikView/expression-for-total-selected-values/m-p/1347728#M841133 Anil_Babu_Samineni 2017-05-02T06:49:28Z Re: expression for total selected values https://community.qlik.com/t5/QlikView/expression-for-total-selected-values/m-p/1347729#M841134 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Can you show your final required output screen.</P><P></P><P>count(&lt;sales-={'-',''}&gt;product)</P><P>or</P><P>count(if(not wildmatch(trim(sales),'-',''),product))</P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Regards,</SPAN></P></BODY></HTML> Tue, 02 May 2017 07:11:32 GMT https://community.qlik.com/t5/QlikView/expression-for-total-selected-values/m-p/1347729#M841134 PrashantSangle 2017-05-02T07:11:32Z Re: expression for total selected values https://community.qlik.com/t5/QlikView/expression-for-total-selected-values/m-p/1347730#M841135 <HTML><HEAD></HEAD><BODY><P>Test done</P></BODY></HTML> Tue, 02 May 2017 07:14:03 GMT https://community.qlik.com/t5/QlikView/expression-for-total-selected-values/m-p/1347730#M841135 Anil_Babu_Samineni 2017-05-02T07:14:03Z