topic Qlikview field value count in QlikView https://community.qlik.com/t5/QlikView/Qlikview-field-value-count/m-p/724793#M473920 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I would like to create a table like:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Table</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Issue1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Issue2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Issue3</STRONG></TH></TR><TR><TD style="padding: 2px;">Food</TD><TD style="padding: 2px;">500</TD><TD style="padding: 2px;">250</TD><TD style="padding: 2px;">12</TD></TR><TR><TD style="padding: 2px;">Clothing</TD><TD style="padding: 2px;">34</TD><TD style="padding: 2px;">666</TD><TD style="padding: 2px;">23</TD></TR><TR><TD style="padding: 2px;">Car</TD><TD style="padding: 2px;">27</TD><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">1</TD></TR></TBODY></TABLE><P></P><P>These issues should be calculated from a table that contains the following:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Table</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Low Fat</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Too big size</TH></TR><TR><TD style="padding: 2px;">Food</TD><TD style="padding: 2px;">UNDEFINED (x500)</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">Clothing</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">UNDEFINED (x34)</TD></TR><TR><TD style="padding: 2px;">Car</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>So basically it needs to add up all the 'UNDEFINED' per row per field. Any idea?</P></BODY></HTML> Tue, 14 Oct 2014 14:53:59 GMT 2014-10-14T14:53:59Z Qlikview field value count https://community.qlik.com/t5/QlikView/Qlikview-field-value-count/m-p/724793#M473920 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I would like to create a table like:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Table</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Issue1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Issue2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Issue3</STRONG></TH></TR><TR><TD style="padding: 2px;">Food</TD><TD style="padding: 2px;">500</TD><TD style="padding: 2px;">250</TD><TD style="padding: 2px;">12</TD></TR><TR><TD style="padding: 2px;">Clothing</TD><TD style="padding: 2px;">34</TD><TD style="padding: 2px;">666</TD><TD style="padding: 2px;">23</TD></TR><TR><TD style="padding: 2px;">Car</TD><TD style="padding: 2px;">27</TD><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">1</TD></TR></TBODY></TABLE><P></P><P>These issues should be calculated from a table that contains the following:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Table</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Low Fat</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Too big size</TH></TR><TR><TD style="padding: 2px;">Food</TD><TD style="padding: 2px;">UNDEFINED (x500)</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">Clothing</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">UNDEFINED (x34)</TD></TR><TR><TD style="padding: 2px;">Car</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>So basically it needs to add up all the 'UNDEFINED' per row per field. Any idea?</P></BODY></HTML> Tue, 14 Oct 2014 14:53:59 GMT https://community.qlik.com/t5/QlikView/Qlikview-field-value-count/m-p/724793#M473920 2014-10-14T14:53:59Z