topic Re: How to remove the first line of a "Table chart" in QlikView

How to remove the first line of a "Table chart"

Fri, 05 Sep 2014 07:39:39 GMT

Hello everyone,

So I have this straight table built with the chart editor. When I load the data the first row of the table does not have any values on any cells, only a dash ( - ) on the corresponding the expression.

The data I load to the table doesn't have any empty line.

How can I prevent this line to show?

Is there any option to hide it?

In attachment there is a image to help understand the issue.

Thank you for the help

Best regards!

Re: How to remove the first line of a "Table chart"

ecolomer — Fri, 05 Sep 2014 07:42:51 GMT

You need to "descheek" total buton

Re: How to remove the first line of a "Table chart"

VishalWaghole — Fri, 05 Sep 2014 07:45:30 GMT

In the straight and pivot table,

first row is nothing but name of column, i don't thing so you can disable it.

If you don't want name of column then left null at lable text, but still it will appear as null.

-- Regards,

Vishal Waghole

Re: How to remove the first line of a "Table chart"

Fri, 05 Sep 2014 07:48:36 GMT

Hi Vishal,

Yes, you are correct, the first line has the name of the columns, so technically what I want gone is the second line XD

The attached image show witch line I want to remove. The line on top of that is the one that has the names of the columns.

Regards

Re: How to remove the first line of a "Table chart"

Fri, 05 Sep 2014 07:50:32 GMT

Hi Enrique,

Thank you for the answer but the "No totals" does not solve the problem

Regards

Re: How to remove the first line of a "Table chart"

IAMDV — Fri, 05 Sep 2014 07:51:05 GMT

Hi,

Looks like you have total calculation enabled. If you want you can disable the total setting by selecting "No Totals" radio button on all the expressions. This only applicable to the expressions tab.

Cheers,

www.QlikShare.com

Re: How to remove the first line of a "Table chart"

tresB — Fri, 05 Sep 2014 07:51:38 GMT

For all the expressions check 'No Total' in total mode option.

Re: How to remove the first line of a "Table chart"

Fri, 05 Sep 2014 07:51:47 GMT

Hi IVo,

If i am not wrong , ur first row is showing the total and that is missing .. just go to presentation tab and select TOTAL ON THE LAST ROW .

Thanks

Re: How to remove the first line of a "Table chart"

Fri, 05 Sep 2014 08:07:48 GMT

So I kinda solved the problem...

I wanted to remove that line because I want to export the table to an excel file and that line was also being exported.

I checked the option "Suppress Header row" on the Presentation tab and now when I export to the file, the empty line it is not shown. So for me this is OK and it works for what I want but the "No Totals" option do not work, the line is still there, but like I was saying when I export to excel it goes away.

Probably when the export is done the first line is removed because the line with the headers was also being removed the first time I exported.

Thank you for the help, and if there is any other things to try to help someone else I could do it.

Best regards!

Re: How to remove the first line of a "Table chart"

VishalWaghole — Fri, 05 Sep 2014 08:12:08 GMT

Nice one... I don't know that property.

Learn something new from you Ivo Marques

-- Thanks and Regards,

Vishal Waghole

Re: How to remove the first line of a "Table chart"

Fri, 05 Sep 2014 08:38:39 GMT

This is just a guess Vishal

From my understanding is how it seems to work.

And more, I export the table to excel with a macro, so the macro itself might have something also to do with this.

Regards!