topic Re: Macro in QlikView

Macro

brindlogcool — Thu, 22 Mar 2012 18:07:47 GMT

Hi,

Is there any way i can store the current selections in a Single variable and pass the varible to excel and store it in a cell. I tried to but i am not able to store all the current selections values in a single variable and paste it in a excel.

Macro

Jason_Michaelides — Thu, 22 Mar 2012 18:28:16 GMT

Doesn't the function GetCurrentSelections() do this?

Macro

Jason_Michaelides — Thu, 22 Mar 2012 18:28:57 GMT

(Or GetFieldSelections() - I can't remember off hand!)

Macro

Thu, 22 Mar 2012 18:33:50 GMT

In user preferences, Export tab, check both boxes under Selection Stamps in Export. That will show all your current selections at the end of the excel spreadsheet.

Re: Macro

brindlogcool — Thu, 22 Mar 2012 18:39:55 GMT

@Jason,

Thanks for your response

Using GetCurrentSelections i can assign it to a variable. Now i found the way to paste in excel but it is getting pasted with rectangle at the end.

@Dreamerlou

Thanks for your response it is working at the client but not on Accesspoint. I have unchecked the Allow Export(As per requirement).

Macro

Jason_Michaelides — Thu, 22 Mar 2012 18:56:40 GMT

Hmmm...probably some weird Excel encoding thing. Try wrapping Text() around your variable.