topic Re: Straight table hide expressions in QlikView

Straight table hide expressions

CVR — Sat, 16 Nov 2024 03:37:32 GMT

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)

Re: Straight table hide expressions

NW1965 — Thu, 09 May 2019 17:35:10 GMT

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

Re: Straight table hide expressions

CVR — Thu, 09 May 2019 17:56:06 GMT

Thanks for your help @NW1965