Solved: Delay object refresh until button pressed? - Qlik Community

Jason_Michaelides · ‎2011-04-21

Hi all,

Do you know of a way I can tell QlikView NOT to redraw displayed objects until a "REFRESH" button is pressed? I have 150m+ rows of data (nice star schema) but objects with lots of set analysis calculations in them. It's frustrating for users to have to wait after each selection when they know you need to make several in one go. I'd like them to make the selections and then press GO.

Thanks,

Jason

rwunderlich · ‎2011-04-21

Here's one posible approach:

1. Use a variable to control the Calculation Condition of the object.
2. In the Document OnAnySelect Trigger, set the varable to false.
3. When the Refresh button is pressed, set the variable to true.

View solution in original post

rwunderlich · ‎2011-04-21

Here's one posible approach:

1. Use a variable to control the Calculation Condition of the object.
2. In the Document OnAnySelect Trigger, set the varable to false.
3. When the Refresh button is pressed, set the variable to true.

Jason_Michaelides · ‎2011-04-21

Rob - you're a star. Thank you so much - I didn't even realise there was a calculate condition! (Must have missed it every day for the last year and a half!!)

Thanks again,

Jason

rwunderlich · ‎2011-04-22

'Theorectically", this technique should not be required. I assume you are using a pre V10 ajax client. Using the windows client or IE plugin, the other listboxes should become ready and available for additional selections while the chart is caclulating. Additional selections should cancel the current chart calculation and drive a new calculation. In V10, ajax is supposed to work this way as well.

I put 'Theorectically" in quotes because I know things sometimes work differently with large datasets. I'd be curious to know if your problem goes away with V10.

Jason_Michaelides · ‎2011-04-22

Unfortunately, Rob - I'm using v10 SR1 desktop client. I know calculations are supposed to be (a?)synchronous now but the recalculating of my main chart does hold everything else up. I'm guessing this is due to the large dataset.

Actually, I used your solution in the SHOW condition, not CALCULATE. On my main chart it still tried to refresh before show "calculation condition not met" or something similar. I think this is due to the "dynamic" lines I have.

Either way, the variable solution is working for me so thanks again.