topic Re: Export to excel in QlikView

Export to excel

gidon500 — Sun, 01 Feb 2015 18:57:35 GMT

I have some objects that i want to export together to one excel sheet

i thought usinf container

like the eclosed document

is it possible to do so ?

enclosed is a sample of container

thanks

gidon

Re: Export to excel

its_anandrjs — Sun, 01 Feb 2015 19:04:44 GMT

Hi,

You can achieve this in the Send to macro Excel and in the macro you have to use two objects data and then end it to single excel sheet.

And you if you need only the straight chart then go to the pdf reports section in the reports wizard and add both objects.

Regards

Anand

Re: Export to excel

gidon500 — Sun, 01 Feb 2015 19:08:36 GMT

thanks Anand

is there an example how to do this ?

gidon

Re: Export to excel

Frank_Hartmann — Sun, 01 Feb 2015 22:20:29 GMT

Have look a this file!!

Hope it helps!

Re: Export to excel

Mon, 02 Feb 2015 18:22:29 GMT

Hi David,

u can solve this problem for every object by three method.

First Method by using option Select Object --> Right Click --> Send to excel (Only data but Representation)

Second Method by using :- Copy to Clipboard --> Object .

it works like dynamically that means Object will be pasted ..if u select a particular data in excel it change like Qlikview Association (here u can select rest of the Tabs and also select the data)

i am taking container as example :-

Third Method by using :- Copy to Clipboard --> Only Images .(here images only will be selected and no Association is not possible .

With Regards,

Venkata.