Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

qlikdash
Contributor II

How to hide Totals row in Straight table

I have a lot of expressions. I do not want the totals row to show. How do I hide it. I know I can hide it at expression level: I have to do "No Totals" for ea expression. Can you suggest how I can hide it with one step or two.

Thanks

15 Replies
MVP
MVP

Re: How to hide Totals row in Straight table

I think that's how you need to do this: Setting total mode to 'No totals' for each and every expression.

sureshqv
Esteemed Contributor III

Re: How to hide Totals row in Straight table

chk dis

nototal.png

hirishv7
Honored Contributor

Re: How to hide Totals row in Straight table

Hi,

I think No other way you can Hide Totals by Selecting  'No Totals' at Total mode as Suresh suggested.For each and every expression.

-Hirish

qlikdash
Contributor II

Re: How to hide Totals row in Straight table

ok sure. I have 100+ expressions! I am as surprised as you are. It looks like that is the only way.

Thanks everyone. will do as recommended

sureshqv
Esteemed Contributor III

Re: How to hide Totals row in Straight table

Please close the thread if u got  the solution by marking correct and helpful answers above.

Thanks

suresh

vsudhakar
Contributor III

Re: How to hide Totals row in Straight table

Go to presntation tab and select the column and give the Hide column than it is go to the hidden

sureshqv
Esteemed Contributor III

Re: How to hide Totals row in Straight table

vsudhakar
Contributor III

Re: How to hide Totals row in Straight table

In expression tab have the no total option and other one is the go to the presentation tab select the column and the select the hidden column the column is go to the hidden

kkkumar82
Valued Contributor III

Re: How to hide Totals row in Straight table

Hi ,

goto view -> click Design Grid

After that right one expression value and see "custom format " option , a window will be opened and change the text color to background and below apply this to all expressions, this will remove all totals.

no totals 1.png

no totals 2.png

May be this helps you.

Thanks

Kiran

Community Browser