topic Re: Document Analyzer v1.13.1 Update in QlikView

Document Analyzer v1.13.1 Update

rwunderlich — Mon, 03 Sep 2012 16:54:36 GMT

An bugfix to Document Analyzer 1.13 is now available on my download page:

This update fixes a mispelling in the macro introduced in V1.13.

Sorry for the inconvienence. If you have DocumentAnalyzer V1.13, I encourage you to replace it with the V1.13.1 version immeadiately.

-Rob

Re: Document Analyzer v1.13.1 Update

pgalvezt — Mon, 03 Sep 2012 17:52:50 GMT

Thank you Rob. One Question can you explain this please?

RequestEdx

Thanks!

Re: Document Analyzer v1.13.1 Update

rwunderlich — Mon, 03 Sep 2012 18:22:38 GMT

If you are asking about the RequestEdx on my downloads page, this is a VBScript used to trigger an EDX (external trigger) task on QV9 & QV10.

-Rob

Re: Document Analyzer v1.13.1 Update

pgalvezt — Mon, 03 Sep 2012 18:25:02 GMT

Perfect!

Great page congratulations!

Thanks Again

Re: Document Analyzer v1.13.1 Update

Tue, 25 Sep 2012 08:50:22 GMT

Hi Rob,

I'm trying this tool.

But is there any ways we can get the info of hidden objects?

For example, i have many sheets on hidden by default.

Thanks,

nick

Re: Document Analyzer v1.13.1 Update

rwunderlich — Tue, 25 Sep 2012 13:07:07 GMT

Hi Nick,

DocumentAnalyzer should process and report on hidden objects just fine. If it's not working for you, can you upload an example where it's not?

-Rob

Re: Document Analyzer v1.13.1 Update

Tue, 25 Sep 2012 13:17:57 GMT

Hi Rob,

I was looking the at the macro. and the following should cover the hidden sheet?

But it still wont detect my hidden sheet.

If sheetObj.GetProperties.Show.Always = False Then

Call writeExpression(sheetObj,sheetObj.Getproperties.Show.Expression.v)

End If

I'm doing something like below in the condition. could this be the cause?

=Sign(Index(GetFieldSelections($TAB_NAME, ',', $(VS_MAXTAB)), 'Receviable')) and V_HOME='REC'
 or
 Sign(Index(GetFieldSelections($PROCESS_NAME, ',', $(VS_MAXTAB)), 'Payable')) and V_HOME='PAY'

So, to bypass this error. i went to the document > security properties, to display all hidden sheets.

then, i load again. and i got an "out of memory" issue. when it's at...

LOAD 
          ExpressionKey,
          trim(subfield(x, '$(delimChar)')) as TempFieldName

This dashboard that i'm loading is around 450MB, and quite heavy on data as we have material number, invoice number and supplier number.

Thanks for your help.

Re: Document Analyzer v1.13.1 Update

rwunderlich — Tue, 25 Sep 2012 15:34:08 GMT

Hi Nick,

Two issues here.

1) I see there is a problem with hidden sheets. Hidden sheets are not getting processed. I don't see a quick solution except for unhiding everything as you have done.

2) The out of memory error is a known problem with documents with many objects. Someone recently provided me with an example doc where this fails but I have not resolved it. I'll post an update when I do.

-Rob

Re: Document Analyzer v1.13.1 Update

Wed, 26 Sep 2012 07:44:18 GMT

Hi Rob,

Thanks for the info.

Awaiting your fix.

Nick

Re: Document Analyzer v1.13.1 Update

rwunderlich — Thu, 27 Sep 2012 21:08:01 GMT

Hi Nick,

I've uploaded a new version, 1.14, to

http://robwunderlich.com/downloads/

This update fixes the "out of object memory" error for very large documents. You will still need to unhide the sheets though.

-Rob