topic filename as caption name while exporting excel in QlikView

filename as caption name while exporting excel

puneetagarwal — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

Can we get the caption name/window title as a filename while exporting the excel.

Eg: if we make a current selection as companyname like 'abc' the window title shows as abc_report, now i want the excel exported should take the name as abc_report.

Is it possible?

Regards,

Puneet

Re: filename as caption name while exporting excel

YoussefBelloum — Tue, 09 Jan 2018 08:52:29 GMT

Hi,

Yes you can do it (maybe not for all types of objects), if we take a straight table:

on the general tab of the object => title of the object => =Getfieldselection(YOUR_FILTER)

like that when you export you will have your selection as a title

Re: filename as caption name while exporting excel

puneetagarwal — Tue, 09 Jan 2018 09:05:58 GMT

Hi Youssef,

Thanks , but its not working.

When we click on send to excel its saving the file-name as default/system generated.

Regards,

Puneet

Re: filename as caption name while exporting excel

YoussefBelloum — Tue, 09 Jan 2018 09:08:14 GMT

What is the object type you are using to do this export ?

Re: filename as caption name while exporting excel

puneetagarwal — Tue, 09 Jan 2018 09:31:04 GMT

As of now i'm using table box.

But tried with straight table as well . its not working.

Regards,

Puneet

Re: filename as caption name while exporting excel

YoussefBelloum — Tue, 09 Jan 2018 09:43:54 GMT

ok, can you take a screen shot on the title expression ?

Re: filename as caption name while exporting excel

puneetagarwal — Tue, 09 Jan 2018 10:17:45 GMT

This is what I have given in title expression

=GetFieldSelections(Product)

Re: filename as caption name while exporting excel

YoussefBelloum — Tue, 09 Jan 2018 10:22:24 GMT

Try to do : SEND TO EXCEL (via right click on the object) and not export

Re: filename as caption name while exporting excel

puneetagarwal — Tue, 09 Jan 2018 10:28:31 GMT

Yes, tried the same .

its not working.