Qlik Sense Document Analyzer V1.1 Released

[rwunderlich]

Finally,  finally, a Qlik Sense version of my popular "QV Document Analyzer" tool is released. It is available for download here:

QS Document Analyzer http://qlikviewcookbook.com/recipes/download-info/qs-document-analyzer/

The tool is provided as a setup.exe that requires windows admin permissions as it installs a custom Qlik script connector.

There are limitations in this release documented in the release notes and the "Introduction" sheet on the qvf.

I'm looking for feedback in terms of problems you may encounter or suggestions.

Let me know how it works out for you!

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[rwunderlich]

Hi Damien,

The current version of QS DA will calc the objects in the default (clear) selection state. Those objects with a calculation condition that requires selections will therefore not calculate. How are you applying a sheet trigger? With an extension?

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[rwunderlich]

I'll test with an = in front of the fieldname to see if that's a bug.  Also, the 1.1 version is only looking at dimension and measures, not expressions like reference lines.

The next version will move the field parsing into the connector which should improve the accuracy.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[saurabh_handa]

Thanks Rob, any tentative timelines by when the next version with fixes would be available?

[rwunderlich]

‌Feb 1.

Rob

[dtr]

Hi Rob, looking forward to the update. Client was very happy to here a new version is coming.

Thanks,

Damien

[dtr]

I had thought I responded previously, but the actual deployed mashup drives default selections when accessing via mashup, and when accessing via QS app we use an extension based trigger object to apply the selections as a button. I attempted to use a sheet event trigger extension as well hoping that may be able to replicate selections being made when each sheet opened, but as your app treats as clear state that wouldn't necessarily work. And unfortunately the data model makes it impossible to have charts work without selections made due to an extensive and complex entitlement and impersonation system in place in the application. Long story short we could fake a user by reducing the data so there was only those options available, but reduced data will calculate quicker and produce false positives for good performance, or we try to find a way to mimic the selection being made . I'm going to be dedicating some time to figuring this one out so I look forward to your updated version, and will be working out some ways on my end to best mimic the data state we need, but if there is any chance for a future release to be able to include a trigger or set default selections that would be fantastic.

Thanks,

Damien

[rwunderlich]

If your focus is performance and you want to apply user scenarios, take a look at the Qlik Sense Scalability Tools (Sense v3.x, June/September/November 2017) if you have not already.  With the tool you can define selections and other user actions and get some performance timings.

So perhaps you can use Document Analyzer for structural information and the scalability tool for more sophisticated performance testing.

-Rob

[ravireddyk]

Hi Rob,

Is there a way to know the what sheets ( Base sheets, community sheets or user sheets) were using calculations , i know there are calculations shown but i am looking by sheet name and there objects, expressions , dimensions and measure and sheet owner id or sheet owner name.

Can we expect this in next release or any work around on this question for future purpose and also any thoughts on server level implementation of document analyzer.

Thanks,

Ravi

[rwunderlich]

Hi Ravinder,

The table on the Objects sheet does show what sheet the object is on.  Is that enough or are you looking for something else?

I'll need to get back to you on the Server question.  I don't have a timeline for that yet.

-Rob

[Danijel]

rwunderlich‌

Really great App! Unfortunatelly i got one Error, but i could not find the reason for that.

Maybe you can help me?

System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

   bei A.a.e.MoveNext()

   bei QlikView.Qvx.QvxLibrary.QvxConnection.WriteTableItemsToStream(QvxDataTable table, Stream pipeStream)

   bei QlikView.Qvx.QvxLibrary.QvxConnection.InternalExecute(DataPipe dataPipe, QvxDataTable table, Action`1 onError, Action clearMExecuteError)

Tested on Qlik Sense November 2017..

Thanks..