How to either avoid or make disappear the total column text

[nevilledhamsiri]

Hi! Dear

appreciate if a solution is proposed in order to either avoid being appeared term " NON PAYABLE' in the last row or to make it disappear in the row. But this needs to be shown as it is in all other rows!

Thanks

Neville

[vvira1316]

Have you tried Label for Totals on Presentation tab

[nevilledhamsiri]

Hi, Viran, will you elaborate how this is done in order to make it disappear. I followed what you said there I do not understand how that is proceeded!

Rgd

Neville

[vvira1316]

Hi,

Please see attached. If you are looking for a different information then please share what you are expecting.

[andrei_delta]

hello!

No, you can't get rid of the the Non-Payable...

[oscar_ortiz]

You can try something like this:

If( Dimensionality() > 0,

     Sum( Field ),

     ''

)

Good luck

Oscar

[nevilledhamsiri]

Dear Oscar,

This is what you propose! the text 'Non Payable" is an expression so is it possible to apply this. Could you please elaborate more on this. Also the expression you propose carries a comma & inward comma & so on which are vague since it is not on a straight line. Please rewrite this.

Thanks In advance!

If( Dimensionality() > 0,

     Sum( Field ),

     ''

)

[oscar_ortiz]

I like to break out my expression, it makes it a bit easier to read:

If( Dimensionality() > 0,     //     Condition to test

     Sum( Field ),               //     Then

     ''                                   //      Else

)

Written as a single line:

If ( Dimensionality() > 0, Your Expression goes here, '' )

good luck

Oscar

[nevilledhamsiri]

Dear Oscar,

Thanks a lot. amazing! It simply worked fine.

Regds

Neville

[oscar_ortiz · Accepted solution]

Not sure if you solved your issue.  But if you have would you mind closing the thread.

Qlik Community Tip: Marking Replies as Correct or Helpful

Thanks

Oscar