topic Re: pass value from qlikview application to excel in QlikView

pass value from qlikview application to excel

Sat, 06 Dec 2014 05:44:16 GMT

I need to create a button with an action that will pass a value to an excel document. I want the excel document to open with charts that are related to that specific value. the excel sheet is done. It has a drop down that changes the values of the charts. I want the drop down and charts to reflect the value i currently have when i press the button in the qlikview app. Any information would be helpful. I have programming experience, but not much with qlikview or vb script. If i can get a high level explanation how this can be accomplished (A to Z)I will do all the rest of the leg work.

Re: pass value from qlikview application to excel

ecolomer — Sat, 06 Dec 2014 07:23:01 GMT

Here you have an example to extort to excel

Re: pass value from qlikview application to excel

alkesh_sharma — Sat, 06 Dec 2014 09:00:55 GMT

You need to do all the slicing and dicing of data in qlikview and than you can export that excel with a button.

But if you want to control excel with qlikview, that won't be possible.

Re: pass value from qlikview application to excel

Sat, 06 Dec 2014 18:39:35 GMT

So, there is no way to capture a variable's value in qlikview and pass it to an excel sheet? And, open the excel sheet based on the value that was passed. For clarification I'm not trying to export to excel. The excel file has all the data I just need a user id from qlikview to show the corresponding data in the excel sheet. this can't be done with vbscript or powershell? how about windows directory?