topic Expression value ...... in QlikView https://community.qlik.com/t5/QlikView/Expression-value/m-p/647361#M237080 <HTML><HEAD></HEAD><BODY><P><BR />I have a table with 2 dimensions plant and material.</P><P>Plant has values FBPL, FCHI, F003, F005....</P><P></P><P></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"><STRONG>Plant</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Material</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>F003</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>F005</STRONG></TH></TR><TR><TD style="padding: 2px;">FBPL</TD><TD style="padding: 2px;">ABC</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">FCHI</TD><TD style="padding: 2px;">XYZ</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P> Now, in F003 column I want count of stock for plant F003 and material ABC ignoring FBPL. Similarly, stock for F005 and XYZ ignoring FBPL.</P><P></P><P>Kindly help!!!</P><P></P><P>Regards,</P><P>Rajeshree</P></BODY></HTML> Thu, 10 Jul 2014 06:05:17 GMT 2014-07-10T06:05:17Z Expression value ...... https://community.qlik.com/t5/QlikView/Expression-value/m-p/647361#M237080 <HTML><HEAD></HEAD><BODY><P><BR />I have a table with 2 dimensions plant and material.</P><P>Plant has values FBPL, FCHI, F003, F005....</P><P></P><P></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"><STRONG>Plant</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Material</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>F003</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>F005</STRONG></TH></TR><TR><TD style="padding: 2px;">FBPL</TD><TD style="padding: 2px;">ABC</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">FCHI</TD><TD style="padding: 2px;">XYZ</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P> Now, in F003 column I want count of stock for plant F003 and material ABC ignoring FBPL. Similarly, stock for F005 and XYZ ignoring FBPL.</P><P></P><P>Kindly help!!!</P><P></P><P>Regards,</P><P>Rajeshree</P></BODY></HTML> Thu, 10 Jul 2014 06:05:17 GMT https://community.qlik.com/t5/QlikView/Expression-value/m-p/647361#M237080 2014-07-10T06:05:17Z Re: Expression value ...... https://community.qlik.com/t5/QlikView/Expression-value/m-p/647362#M237081 <HTML><HEAD></HEAD><BODY><P>You say that "<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Plant has values FBPL, FCHI, F003, F005</SPAN>". But this is not reflected in the table... You have some plant values as values to the left, and other plant values as column headers to the right. This doesn't make sense.</P><P></P><P>So you need to explain more what your requirements are.</P><P></P><P>HIC</P></BODY></HTML> Thu, 10 Jul 2014 06:44:18 GMT https://community.qlik.com/t5/QlikView/Expression-value/m-p/647362#M237081 hic 2014-07-10T06:44:18Z