topic Re: Table without header in QlikView

Table without header

Anonymous — Tue, 01 Oct 2013 13:40:23 GMT

Hi,

i have a diagram table with two colums. Title bar shows formula, header line1 “structure_name” and header line2 “Sum(cost_eur)”. Now, I would like to show header line in title bar. The table should have no header line.

old design

new design

Regards Stefan

Re: Table without header

Tue, 01 Oct 2013 13:44:44 GMT

Is it as easy as this or have I over simplified the issue? I've simply put a [Space] in for the title names.

Steve

Re: Table without header

Anonymous — Tue, 01 Oct 2013 13:59:22 GMT

Hi Steve,

that's fine. And now, how can i show the header line in the title bar? With formula...?

Stefan

Re: Table without header

Tue, 01 Oct 2013 14:08:23 GMT

Hi Stefan

In my example qvw I sent through, I simply inputted the title on the properties of the object (on the 'General' tab). Would this suffice?

Steve

Re: Table without header

Anonymous — Tue, 01 Oct 2013 14:12:51 GMT

Hi Steve,

i've seen, but i would like to prefer with fomular.

Stefan

Re: Table without header

Anonymous — Tue, 01 Oct 2013 14:19:27 GMT

Stefan

Why not get rid of the Caption instead ?

In the Caption tab of the table properties deselect <Show Caption>.

Then in the Table Header you can whack in whatever you want.

Best Regards, Bill

Re: Table without header

Tue, 01 Oct 2013 14:30:21 GMT

Hi Stefan

Use;

=GetObjectField()

This will get you structure_name, however there is no facility to list the expression as listed. This you will have to type in. Of course, the GetObjectField will only provide the first dimension, Use GetObjectField(2) for the next dimension and so on.

I hope that answers your question. Let me know how you get on.

Regards

Steve

Re: Table without header

Anonymous — Wed, 02 Oct 2013 09:46:13 GMT

Hi Steve,

there's something wrong? Title bar doesn't show Fieldname? Can you send me a qvw file?

Stefan

Re: Table without header

Wed, 02 Oct 2013 09:53:17 GMT

Isn't this what you need?

Re: Table without header

Anonymous — Wed, 02 Oct 2013 10:48:27 GMT

Hi,

sorry, i can't open this file. It's a license problem.

Stefan

Re: Re: Table without header

Wed, 02 Oct 2013 11:41:12 GMT

Hi Stefan

Please find attached file with the answer. Apologies my earlier file referred to GetObjectField(2); this would bring back the 3rd dimension.

The first dimension can be shown via;

GetFieldObject() or GetFieldObject(0)

I hope this answers your question.

Regards

Steve