topic Skip zero values while working with crosstable ? in QlikView https://community.qlik.com/t5/QlikView/Skip-zero-values-while-working-with-crosstable/m-p/426091#M158737 <HTML><HEAD></HEAD><BODY><P>I have a record with twelve amount fields, one for each month in the year. Some month have a zero amount.&nbsp; I use a crosstable to split the fields in seperate records. The result is ok, but i get several records with an amount value of zero. Is there a way where i can skip the records which result in a zero value ? </P></BODY></HTML> Thu, 18 Oct 2012 08:41:14 GMT 2012-10-18T08:41:14Z Skip zero values while working with crosstable ? https://community.qlik.com/t5/QlikView/Skip-zero-values-while-working-with-crosstable/m-p/426091#M158737 <HTML><HEAD></HEAD><BODY><P>I have a record with twelve amount fields, one for each month in the year. Some month have a zero amount.&nbsp; I use a crosstable to split the fields in seperate records. The result is ok, but i get several records with an amount value of zero. Is there a way where i can skip the records which result in a zero value ? </P></BODY></HTML> Thu, 18 Oct 2012 08:41:14 GMT https://community.qlik.com/t5/QlikView/Skip-zero-values-while-working-with-crosstable/m-p/426091#M158737 2012-10-18T08:41:14Z