New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
New Contributor III

Straight table hide expressions

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)

Labels (4)

• Straight table expression

1 Solution

Accepted Solutions
Contributor

Re: Straight table hide expressions

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
2 Replies
Contributor

Re: Straight table hide expressions

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
New Contributor III