topic Re: How to remove the empty line between title and the table? in QlikView

How to remove the empty line between title and the table?

Thu, 27 Nov 2014 15:51:41 GMT

Hey everyone,

I used to have a table (the kind of table in which you can just put fields but not expressions) and I moved it to a table (like graph) in which I added an expression.

But now there is an empty row between the line with the names of fields and the data. Can I remove it ?

Thanks

ps : It is a requirement from one of my users who exported this table to excel and probably has got some program running on it.

Re: How to remove the empty line between title and the table?

Frank_Hartmann — Thu, 27 Nov 2014 15:56:07 GMT

disable total value properties-----> expressions------> Total mode

Re: How to remove the empty line between title and the table?

Thu, 27 Nov 2014 15:58:14 GMT

Thanks

I had already done it but I forgot one of the expressions

Re: How to remove the empty line between title and the table?

Thu, 27 Nov 2014 15:58:55 GMT

Hi Laura,

If your new chart is a straight chart, then go to the properties->expression-> select No Totals for all Expressions

IIf your new chart is a straight chart, then go to the properties->Presentation->uncheck the Show Partial Sums foar all Dimensions

Hopr it helps !

Cheers !