Straight table hide expressions

[CVR]

Hello Qlik Geeks,

 I have a straight table one dimension and  6 expressions. How Can I make all expressions in a two column as A1 and A2 and remove all zero value rows?

like this

Note : the dimension is Year(fieldname) 

[NW1965 · Accepted solution]

With that much information I'm going to guess, so let's assume that your expressions are currently something simple like: Sum(A1); Sum(A2); Sum(B1); Sum(B2); Sum(C1); Sum(C2) If this, by some miracle, is indeed the case then make your two expressions like this: First Column = Sum(A1) + Sum(B1) + Sum(C1) Second Column = Sum(A2) + Sum(B2) + Sum(C2) Then, the suppress zeros and suppress missing should deal with the blank rows

[CVR]

Thanks for your help @NW1965