Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nevilledhamsiri
Specialist
Specialist

How to either avoid or make disappear the total column text

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

1 Solution

Accepted Solutions
oscar_ortiz
Partner - Specialist
Partner - Specialist

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

View solution in original post

9 Replies
vvira1316
Specialist II
Specialist II

Have you tried Label for Totals on Presentation tab

LabelsforTotal.PNG

nevilledhamsiri
Specialist
Specialist
Author

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
Specialist II
Specialist II

Hi,

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

LabelsforTotal2.PNG

andrei_delta
Partner - Creator III
Partner - Creator III

hello!

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

oscar_ortiz
Partner - Specialist
Partner - Specialist

You can try something like this:

If( Dimensionality() > 0,

     Sum( Field ),

     ''

)

Good luck

Oscar

nevilledhamsiri
Specialist
Specialist
Author

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
Partner - Specialist
Partner - Specialist

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
Specialist
Specialist
Author

Dear Oscar,

Thanks a lot. amazing! It simply worked fine.

Regds

Neville

oscar_ortiz
Partner - Specialist
Partner - Specialist

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