topic Re: export to excel only possible selection values. in QlikView

export to excel only possible selection values.

Sat, 24 Dec 2011 10:53:51 GMT

Hi all,

Can we export the only possible data values of the listbox into excel.

Ex: if Field "A" is having total 6 values in the listbox, after filtering the "A" listbox is having possible selections like 1 and 6.

Now when i export to Excel it should show the values only 1 and 6 , but i am getting the values of all the Field "A" which are having.

Is this possible to export only possible selection values into excel.

please find the attached sample file.

Thanks in advance.

Re: export to excel only possible selection values.

IAMDV — Sun, 25 Dec 2011 17:39:29 GMT

Hi,

There is no straight way to do this task. Because even if you select hide excluded as ListBox property, you will see the exluded values in Excel. You should write VB Script to get this working. However, the easiest way is to right click on the field and then click copy to clipboard on then select possible values. Then you can go to Excel and paste the data in Excel. If you wanted to automate then you need to follow similar approach and write VB Script.

I hope this helps!

Cheers - DV

Re: export to excel only possible selection values.

Mon, 26 Dec 2011 07:12:34 GMT

Hi D V,

Can you please provide VB Script for this.

Thanks in advance.

Re: export to excel only possible selection values.

Thu, 29 Dec 2011 10:11:14 GMT

Hi All,

Can any one please suggest me how can i export only the selected values of listbox to excel.

Thanks in advance..