Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
CHVR
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?

789.PNG

 

like this

 

10.PNG

 

Note : the dimension is Year(fieldname) 

 

1 Solution

Accepted Solutions
NW1965
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
NW1965
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
CHVR
New Contributor III

Re: Straight table hide expressions

Thanks for your help @NW1965