topic Re: Macros. Autofilter in QlikView

Macros. Autofilter

MindaugasBacius — Mon, 23 Jan 2017 14:48:26 GMT

Hello,

I would like to filter out some values using Macros.

Unfortunately, I only manage to create a filter in excel but no luck with selecting the data in specified column.

How could I achieve my goals?

XLDoc.Sheets(1).Range("A1").AutoFilter

Thank you!

Re: Macros. Autofilter

marcus_sommer — Mon, 23 Jan 2017 15:19:51 GMT

I hope it's helpful: http://www.ozgrid.com/VBA/autofilter-vba-criteria.htm

- Marcus

Re: Macros. Autofilter

MindaugasBacius — Tue, 24 Jan 2017 07:22:11 GMT

I've come across this site yesterday. Sadly, I've tried a lot of variations but with no result.

Re: Macros. Autofilter

marcus_sommer — Tue, 24 Jan 2017 07:31:04 GMT

I think vbs goes straight through the order of parameters and didn't need / accept the parameter-names. I have now looked into a very old reporting of mine which worked at this time - here a snippet from them:

xlSheet.Activate

xlSheet.Cells(1, 1).Activate

xlSheet.Cells(1, 1).Autofilter 3, year(now() - 1)

xlSheet.Cells(1, 1).Autofilter 4, month(now() - 1)

xlSheet.Rows("2:" & xlZeile_1).Select

xlSheet.Rows("2:" & xlZeile_1).Delete

xlSheet.Cells(1, 1).Select

xlSheet.Cells(1, 1).Autofilter

- Marcus

Re: Macros. Autofilter

MindaugasBacius — Tue, 24 Jan 2017 07:39:17 GMT

I did manage to do this!

XLDoc.Sheets(1).Rows("1:1").AutoFilter 13, "<>0"

Thank you Marcus for your professional help!