topic Copy data from Straight table and paste that data to excel sheet in QlikView

Copy data from Straight table and paste that data to excel sheet

Anonymous — Tue, 17 Jun 2014 06:20:25 GMT

Hi All,

Copying data from table box is easily pasted to excel sheet using 'copy data' icon available in the caption tab of chart properties .

But it fails when I used straight table.

Could anyone tell how will I implement it using straight table.

I do not want to use 'send to excel' feature,I just want to copy the data from straight table and paste that data to excel sheet.

Thanks and Regards

Geeta

Re: Copy data from Straight table and paste that data to excel sheet

tresB — Tue, 17 Jun 2014 06:24:36 GMT

Have you tried like:

Right click on chart->Copy to clipboard->table data area ?

Re: Copy data from Straight table and paste that data to excel sheet

jagan — Tue, 17 Jun 2014 06:28:03 GMT

Hi,

Try

Right click on chart->Copy to clipboard->table data area for only data

Right click on chart->Copy to clipboard->Full Table (with headers)

Regards,

Jagan.

Re: Copy data from Straight table and paste that data to excel sheet

Anonymous — Tue, 17 Jun 2014 06:29:23 GMT

Hi,

Thanks for replying.

I have tried

Right click on chart->Copy to clipboard->table data area

But it failed.

Thanks

Re: Copy data from Straight table and paste that data to excel sheet

Anonymous — Tue, 17 Jun 2014 06:30:45 GMT

Hi,

This is not working in the case of straight table.

Thanks

Re: Copy data from Straight table and paste that data to excel sheet

dharmarasu — Tue, 17 Jun 2014 06:30:59 GMT

Hi,

I tried with straight table. its working fine.

In caption tab->special icons->Copy Data(check this)

By clicking copy data icon in Straight table caption and paste it in the excel sheet.

-Dharma

Re: Copy data from Straight table and paste that data to excel sheet

tresB — Tue, 17 Jun 2014 06:31:04 GMT

'failed' - means? what is the issue? gets hanged?

Re: Copy data from Straight table and paste that data to excel sheet

ashfaq_haseeb — Tue, 17 Jun 2014 06:31:15 GMT

Both of them works for me.

Please find the document attached for your reference.

What version of Qlikview you are on. I tried on 11.2 sr6.

This feature will not work on ajax.

may be you can try with Qlikview Plugin.

Hope it help

Regards

ASFAQ

Re: Copy data from Straight table and paste that data to excel sheet

dharmarasu — Tue, 17 Jun 2014 06:35:18 GMT

try with

Copy to clipboard->Full Table also working in straight table

Re: Copy data from Straight table and paste that data to excel sheet

jagan — Tue, 17 Jun 2014 06:37:12 GMT

Hi,

In which mode you are trying (QV Desktop / Plugin / Ajax), this works in Desktop and IE Plugin versions.

Regards,

Jagan.

Re: Copy data from Straight table and paste that data to excel sheet

Anonymous — Thu, 19 Jun 2014 08:26:20 GMT

Hi Ashfaq Mohammed,

You are right .

Due to change in version , data is not copied from the straight table.

I came to know to this point when I updated my qlikview version from 11.2 sr4 to 11.2 sr6 and

created a new qvw file using the binary load of my previous qvw file .

I have created new qvw file beacuse the previous file was giving the same problem when I opened it in the updated version.

Copy data feature of straight table works fine in the newly created file

But due to binary load I did not get back , the front end of my application.

Can you tell some alternative, so that I get the front end of my application back ?

Waiting for your response.

Thanks and Regards

Geeta

Re: Copy data from Straight table and paste that data to excel sheet

ashfaq_haseeb — Thu, 19 Jun 2014 08:31:40 GMT

Hi,

Geetha Binary load will just return you back your Data-model.

For front end you can use copy paste function from old file to new file.

or Rob Wunderlich can suggest any automate way if available.

Regards

ASHFAQ