topic Re: How to hide Totals row in Straight table in QlikView

How to hide Totals row in Straight table

Anonymous — Mon, 22 Feb 2016 21:47:03 GMT

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

Re: How to hide Totals row in Straight table

swuehl — Mon, 22 Feb 2016 21:51:16 GMT

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

Re: How to hide Totals row in Straight table

Chanty4u — Tue, 23 Feb 2016 04:43:54 GMT

chk dis

Re: How to hide Totals row in Straight table

HirisH_V7 — Tue, 23 Feb 2016 04:57:20 GMT

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

Re: How to hide Totals row in Straight table

Anonymous — Tue, 23 Feb 2016 05:09:47 GMT

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

Re: How to hide Totals row in Straight table

Chanty4u — Tue, 23 Feb 2016 05:11:33 GMT

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

Thanks

suresh

Re: How to hide Totals row in Straight table

Anonymous — Tue, 23 Feb 2016 05:20:29 GMT

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

Re: How to hide Totals row in Straight table

Chanty4u — Tue, 23 Feb 2016 05:22:53 GMT

Hi,

Qlik Community Tip: Marking Replies as Correct or Helpful

Re: How to hide Totals row in Straight table

Anonymous — Tue, 23 Feb 2016 05:27:56 GMT

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

Re: How to hide Totals row in Straight table

kkkumar82 — Tue, 23 Feb 2016 05:40:03 GMT

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.

May be this helps you.

Thanks

Kiran

Re: How to hide Totals row in Straight table

Anonymous — Tue, 23 Feb 2016 06:20:40 GMT

thats to format the color, display etc attributes of cells not for Totals option. Thx for trying

Re: How to hide Totals row in Straight table

Anonymous — Tue, 23 Feb 2016 06:25:05 GMT

can you read my original post. I already knew showing no totals in expression was a soln, unfortunately your soln does not qualify as the correct answer.

Re: How to hide Totals row in Straight table

PradeepReddy — Tue, 23 Feb 2016 06:36:03 GMT

in expression tab, at a time you can perform operations on single expression only.. you can't select both the expressions at a time

Ex: Conditional enable of Expression

Re: How to hide Totals row in Straight table

kkkumar82 — Tue, 23 Feb 2016 06:59:08 GMT

Hi ,

Change the text color to background color so that you won't see the totals. this is a work around for your requirement.

thanks

Kiran Kumar

Re: How to hide Totals row in Straight table

Mahamed_Qlik — Tue, 23 Feb 2016 07:32:52 GMT

Hi,

It should be possible by writing an macro for it.

Please ask for macro expert.

Regards,

Mahamed

Re: How to hide Totals row in Straight table

Chanty4u — Tue, 23 Feb 2016 08:31:14 GMT

it hide the colum but not the total ?