topic AW:Re: Export Title from an Object (Table,..) to Excel in QlikView

Export Title from an Object (Table,..) to Excel

Wed, 04 Aug 2010 10:52:12 GMT

Hi,

is there a way, when I'm doing an Excel Export from a table in QlikView to Excel not only export the data from the table. I need also, that QlikView exports the Title of the Object into Excel.

Is there a way to achive this?

Thanks in advance.

Export Title from an Object (Table,..) to Excel

deepakk — Wed, 04 Aug 2010 12:37:25 GMT

For a long time I was searching for a solution for the same but couldnt find a correct way to do this

But you can mention enter the title in ObjectID. hence when we export the data the filename is same as the data in the ObjectID

Export Title from an Object (Table,..) to Excel

Fri, 06 Aug 2010 07:42:54 GMT

Hi,

thanks for your answer.
But only changing the object ID is not the solution I'm searching for.
I need to create a variable f.e. "let bla = today()"

Now im using the variable "=bla" for the title in the table.
I need the actual date, when exporting the excel file.
With the object ID it isn't possible to set a variable.

So I think there's no solution up yet.
Anyways, thanks for your tip.

AW:Re: Export Title from an Object (Table,..) to Excel

brenner_martina — Fri, 06 Aug 2010 08:14:24 GMT

Hi, Mr. Hofbauer,

what about entering the aktual date in the label of the first dimension: ='Label ' & Today()

AW:Re: Export Title from an Object (Table,..) to Excel

brenner_martina — Fri, 06 Aug 2010 08:15:38 GMT

Hi, Mr. Hofbauer,

what about entering the actual date in the label of the first dimension: ='Label '&Date(Today())

AW:Re: Export Title from an Object (Table,..) to Excel

Tue, 17 Aug 2010 07:01:51 GMT


Martina wrote:
Hi, Mr. Hofbauer,
what about entering the actual date in the label of the first dimension: ='Label '&Date(Today())<div></div>

Hi Martina,

I don't really know what you mean with entering the actual date in the label.
Can you give me a short qv-example?

Thank you very much.