topic Button in QlikView

Button

Fri, 18 Feb 2011 05:27:47 GMT

hi,

How to work on with buttons of "copy current page to clipboard", "send data to tab delimited file". Please give me the solution with some example.

Thnks

Button

maneshkhottcpl — Fri, 18 Feb 2011 06:12:45 GMT

Hi,

U want to copy the objects of sheet or the entire sheet as objects?

Button

deepakk — Fri, 18 Feb 2011 06:14:37 GMT

hi venkat,

I was wondering, do you want to export the data to excel or a text format. I would suggest you do it in a single click of a button.

I hope the attach application helps you out.

Button

Fri, 18 Feb 2011 06:15:32 GMT

hi thnks for reply,

please can you provide in both ways.

Thnks

Button

Fri, 18 Feb 2011 06:17:56 GMT

hi Deepak thnks for ur reply,

I am not full licensed version of the QlikView file, so please can you provide screenshots of that attachements.

Thnks

Button

maneshkhottcpl — Fri, 18 Feb 2011 06:23:17 GMT

hi,

Use this expression to copy the object in clip board

and then paste anywhere usin ctrl+v

ActiveDocument.GetSheetObject(

"CH1632").CopyBitmapToClipboard

Need more ?

Button

Fri, 18 Feb 2011 06:26:18 GMT

can you explain clearly and with example. I am new QlikView development.

Thnks

Button

deepakk — Fri, 18 Feb 2011 06:33:22 GMT

hi Venkat.

Below is the code which we write in Macro Editor (Ctr +M)

sub test

set Graph = ActiveDocument.GetSheetObject("CH01")

Graph.Export "C:\test.xls",CHR(9)

end sub

where "CH01" is the Chart objectID. you will find the General tab of Chart properties.

CHR(9) is code for tab .

You can also change the .xls file .txt.

Now Create a Button and add an action to it.

Properties-->Action--> External-->Run Macro and now the macro name i,e test.

I hope this helps.

Button

Mon, 21 Feb 2011 14:07:09 GMT

hi Manesh,

I want to copy the entire sheet as objects.

Can you provide with example and screenshot

Thnks

Button

maneshkhottcpl — Tue, 22 Feb 2011 03:27:16 GMT

Hi,

To copy the entire sheet u can use

ActiveDocument.Activesheet.CopyBitmapToClipboard

after running this macro u can use ctrl+v anywhere to paste the sheet as image.

U can also create a power point presentation of the sheet , please refer the Attached document.

Please let me inform i m correct or not.

Button

Wed, 11 May 2011 12:02:29 GMT

hi,

is it possible after that i sent to ppt to print the ppt?

Thankx at all