Extracting data from Qlik View

[#1]

Hi all,

I am looking at creating a tool for our sales people to use to sell different aspects of our database at differing rates and would like to be able to extract the values from each selection box into a text/excel document to be able to put into a contract.

Does anyone have any ideas on this please? Your help is much appreciated

Chris

[gauravkhare]

Hi Chris,

It's quite easy to extract data from QlikView.

Firstly whenever you are creating a chart-straigh or pivot, they have an icon and by clicking on them you can send your data to excel...Alternately you can also go to properties by right clicking on the chart and from there also you can select the option of sending/exporting your data to excel or csv format

[gauravkhare]

again you can create a button and on it's click event you can define execution of a macro which will send data to excel file(s). Your client only needs to click on that button and the data will be captured in excel format.

[#4]

Is there a way of extracting the selected values in all of the list boxes on a tab (or specific list boxes that I select)? We would probably look at some form of VB code to do this but is this possible?

[suniljain]

With the help of macro you can export value after required selection.

pls study APIGuide.qvw for more details.

[gauravkhare]

Hi Chris,

Surely we do an option of exporting only selected values.

Just for example you have a listbox containing months. Now when you select a particular month then the values in the corresponding chart(s) or in the listboxes will change accordingly.

Now when you will click on the button you've created which contains the coding for sending the data to excel format will get executed. I say that when you want to export bulk data to excel then wited your macro accordingly to that or you can simply write macros on the click event of the button.

Note that QlikTech rescommends to write the coding in visual basic as javascript is also there as an option but it's usage might not yield the desired results. Also don't forget to select the option- Allow System Access.