topic Re: Macro in QlikView

Macro

Mon, 26 May 2014 08:57:18 GMT

HI,

I need to copy Qlikview chart value into clipboard and need to get that value in Qlivkiew.I wrote macro as

sub Test

ActiveDocument.GetSheetObject("CH131").CopyTableToClipboard true

This will copy chart 131 value into Clipboard.

I am not getting how to paste it in Qlikview.

Can anyone please help ASAP.

tresB — Mon, 26 May 2014 09:04:29 GMT

Where do you want it to paste? QlikView sheet? I guess that is not possible. You can rather export it to excel or so like:

Doc.GetSheetObject(var).CopyTableToClipBoard TRUE

xlApp.ActiveSheet.Paste

jagan — Mon, 26 May 2014 09:08:31 GMT

Hi,

Where you want to Paste this? Just press Ctrl+ v as the value is on clipboard. or check for Send keys in macro.

SendKeys "^ve~"

Regards,

Jagan.