topic Re: make all selections in large dashboard in QlikView

make all selections in large dashboard

kris_vliegen — Wed, 11 Oct 2017 09:45:09 GMT

Hi all,

I have a very large dashboard (2,2 Gb) and making selections is taking some time to get a reaction from the dashboard.

Is there a way that the user can make all his selections and than via a button make the selections active.

REgards,

Kris

Re: make all selections in large dashboard

Anil_Babu_Samineni — Wed, 11 Oct 2017 09:48:48 GMT

Yes, There is a way using Triggers. But, I worked around 14 GB application without getting any filter issue and others for one of my client. Can you try using Document Analyze application to check the index.

Re: make all selections in large dashboard

kris_vliegen — Wed, 11 Oct 2017 09:51:03 GMT

Hi,

I mean that a user selects a station, an article, ... And at the and filter all the data in the dashboard with the selections that are made.

What do you mean with Document Analyze application?

Re: make all selections in large dashboard

Anil_Babu_Samineni — Wed, 11 Oct 2017 09:57:16 GMT

Read this - Document Analyzer V3.0 Update Available

Off course, This will happen when your data size is huge

Re: make all selections in large dashboard

kris_vliegen — Wed, 11 Oct 2017 12:26:59 GMT

Hi,

I try to open the document in the document analyser on my pc. But my pc runs out of memory.

But this is what I see in the Governance dashboard.

Re: make all selections in large dashboard

marcus_sommer — Wed, 11 Oct 2017 12:30:51 GMT

Maybe this german discussion is helpful: Auswertung erst starten, wenn alle Selektionen getroffen sind.

- Marcus

Re: make all selections in large dashboard

kris_vliegen — Thu, 12 Oct 2017 14:12:12 GMT

Hi Marcus,

thanks for the link.

If I make a selection on the first tab, Does this calculate the graphs on the other tabs? Or is the calculation just happening when I go to that tab?

Re: make all selections in large dashboard

marcus_sommer — Thu, 12 Oct 2017 14:29:45 GMT

Selections will applied globally (unless you used alternate state) but it will be only visible objects calculated. This meant per condition hidden objects or objects on other sheets are not calculated.

- Marcus

Re: make all selections in large dashboard

kris_vliegen — Tue, 17 Oct 2017 12:53:20 GMT

I've used the docmunt Analyzer.

But this recommands to create a prj-directory.

I have never used Prj-directories.

Why should I use a project?

I've created a button to switch some graphs between quantity and amount.

Should I create a graph per variable or can I use an if-statement in the expression?

Or should I use the condition by the expression?

Re: make all selections in large dashboard

marcus_sommer — Thu, 19 Oct 2017 07:35:49 GMT

I think using a project with the prj-folder feature won't help you by your performance-issues. AFAIK the main-targets of using prj is quite different to performance else more in the direction of backup, maintainability and versioning.

Instead of this using the document analyzer and the governance dashboard could be very useful to find possible reasons for permformance-issues like unused fields, a high cardenality of fields (high amount of distinct field-values) and also the complexity of expressions.

As far as possible if-expressions and aggr-functions in expressions/dimensions especially if they are further nested should be avoided because they could slow down the performance quite heavily.

And this might be also lead to considerations about the used datamodel which should be rather not have a snowflake-scheme or even a linktable approach.

- Marcus