topic Re: export to excel with condition using macros in QlikView

export to excel with condition using macros

Tue, 11 Feb 2014 08:22:35 GMT

Hi,

I want export to my datas to excel using macros but i want export my data with some condition

for example I have an table with date,name and data in that i have date from 11-02-2014 to 21-02-2014 my condition is i want to export the data which is after 16-02-2014 i.e.,from 16-02-2014 to 21-02-2014.

I have attached a sample qvw file with this mail please help me..

Thanks in advance...

Re: export to excel with condition using macros

gonzaloruizgonz — Tue, 11 Feb 2014 08:27:50 GMT

You can probabily use this macro:

Sub sat

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportEx "C:\test.qvd", 4

end sub

där 4 = QVD You need to have 5 how is excel.

Sub sat

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportEx "C:\test.qvd", 5

end sub

BR //Gonza

Re: export to excel with condition using macros

Tue, 11 Feb 2014 08:41:31 GMT

Thanks but I need a data only from 16-02-2014 to 21-02-14 and I don't need other dates and all if i export to excel means i want data like this..

Date	Data	Name
16-02-14	71	F
17-02-14	2	G
18-02-14	114	H
19-02-14	16	I
20-02-14	95	J
21-02-14	46	K

Re: export to excel with condition using macros

giakoum — Tue, 11 Feb 2014 08:42:00 GMT

and add the condition as follows (example):

ActiveDocument.Fields("Month").Select ">4"

ActiveDocument.Fields("Month").ToggleSelect "<8"

Re: export to excel with condition using macros

Tue, 11 Feb 2014 08:52:59 GMT

No its not working how can i get a range between this or what is the macro to get a specific date in a field..?

Re: export to excel with condition using macros

gonzaloruizgonz — Tue, 11 Feb 2014 08:57:38 GMT

Yes, you can put your date in a variable and use them in a setanalys exprexion on a pareto select inside en action. There is probabily more ways to do it, search for "date select", you will probabily found a lot of stuff.

//Gonza

Re: export to excel with condition using macros

Tue, 11 Feb 2014 09:47:30 GMT

No I am asking in macro neither not in set analysis nor pareto im asking for a vb scripts..?and export to excel in macro with condition..

Re: export to excel with condition using macros

gonzaloruizgonz — Tue, 11 Feb 2014 10:33:03 GMT

Ohhhh , you can probabily add one of the follow rows into the macro:

ActiveDocument.Fields("date").Select ("(16-02-2014|21-02-2014)")

ActiveDocument.RecallDocBookmark "selection"

I used the second one the i use a bookmark.

BR//Gonza

Re: export to excel with condition using macros

Tue, 11 Feb 2014 11:43:58 GMT

no its not working can you give some other examples ..

Re: Re: export to excel with condition using macros

gonzaloruizgonz — Tue, 11 Feb 2014 11:57:27 GMT

Sure, here you are.

Re: export to excel with condition using macros

Tue, 11 Feb 2014 14:10:25 GMT

thanks gonzalo this what i need but if there is chance for exporting those data without selection in a chart..?

Re: export to excel with condition using macros

gonzaloruizgonz — Tue, 11 Feb 2014 14:16:42 GMT

Yes, modifie the macro to this one:

Sub sat

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportEx "C:\test.xls", 5

end sub