topic Re: Activate sheets on button click in QlikView

Activate sheets on button click

Tue, 31 May 2016 11:37:06 GMT

Hello,

Is there a way to make all charts\tables\etc that locates on the dashboard to be static until user clicks a button to activate them?

We have a massive amount of data, and it would be preferred if there was no pre-loading on the graphs when you switch tab. So, when you switch a tab, it stays static graph, user makes selections from filters and then clicks a button to activate them.

Any built-in capabilities in QlikView? Or do I have to make some expressions for every chart?

Cheers,

Niko

Re: Activate sheets on button click

Clever_Anjos — Tue, 31 May 2016 11:44:18 GMT

Create a variable (vCalc for example) and set it to 0
All objects that should not be calculated set "Calculation Condition" (at general tab) = vCalc
Your button will have an action Set Variable vCalc = 1

Re: Activate sheets on button click

Tue, 31 May 2016 11:57:09 GMT

Hello, a good suggestion but it does not show any data when user would click a button again for example.

Preferred would be something to do with the attach and detach functionalities. Detach does not react to any user selections and attach does, I think the solution lies somewhere there. But how could I detach and attach these with a single button?

Cheers,

Niko

Re: Activate sheets on button click

Clever_Anjos — Tue, 31 May 2016 12:48:51 GMT

There´s no action to detach/attach an object, but a macro can do this (be aware of this Macro on AJAX or IE Plugin

Another solution would be (depends what you really want)

Create an alternate state
The button would copy the state from one state to another

Re: Activate sheets on button click

Tue, 31 May 2016 13:13:12 GMT

You could make use use calculated conditions for each graph object. Thus only once certain list box selections are made, will the object calculate. This can be found on the general tab of the graph object.

Regards,

Pravesh

Re: Activate sheets on button click

beck_bakytbek — Tue, 31 May 2016 13:27:22 GMT

Hi Niko

do you mean this case, here is my simply example:

beck

Re: Activate sheets on button click

santiago_respane — Tue, 31 May 2016 14:03:09 GMT

Hi man,

once i had to do that and my solution was to have an unlinked copy of the fields and when the user is donde selecting presses a button firing a trigger that copies the selection in the linked fields and enables the tab.

In the first tab i had only the selection list boxes for the unlinked fields and the button, the table charts in other tabs.

Although i would also see any way of reducing the massive amount of info, maybe with aggregation of historic or something.

Hope this helps you.

Kind regards,

Re: Activate sheets on button click

kamal_sanguri — Tue, 31 May 2016 14:10:29 GMT

Just minimize all the objects which you don't want to get calculated while loading app.. they will only be calculated once you restore them.. so, if you want to use a button to do this.. just set that button to restore those minimize objects..

-Kamal

Re: Activate sheets on button click

Anonymous — Tue, 31 May 2016 14:19:22 GMT

Hi Cleven Anjos,

Show your objects at start with the minimum possible dimensions, and hide all objects that you don't want to show at start with hidden option.

Kind regards.

Re: Activate sheets on button click

cwolf — Tue, 31 May 2016 14:39:51 GMT

Hi,

you can do that with a simple macro:

Sub ActivateCharts

Charts=Array("CH01","CH02")

'attach the charts

for each chart in Charts

set chartObj = ActiveDocument.GetSheetObject(chart)

set prop = chartObj.GetProperties

prop.Detached = false

chartObj.SetProperties prop

'wait for calculation

ActiveDocument.GetApplication.WaitForIdle

'detach the charts

for each chart in Charts

set chartObj = ActiveDocument.GetSheetObject(chart)

set prop = chartObj.GetProperties

prop.Detached = true

chartObj.SetProperties prop

end sub

Regards

Christian

Re: Activate sheets on button click

Wed, 01 Jun 2016 05:30:18 GMT

Thank you for you all, I will take a look on these a little bit better tomorrow when I am working again with this issue

Cheers,

Niko

Re: Activate sheets on button click

amit_saini — Wed, 01 Jun 2016 05:45:38 GMT

Hi ,

Hope this will help u!

Thanks,

Re: Activate sheets on button click

Wed, 08 Jun 2016 10:26:05 GMT

This is what we generally now use, thank you

Sorry for the late reply and correct answer -tagging.

Cheers,

Niko