topic Re: Button to activate the list box selections in QlikView

Button to activate the list box selections

Wed, 10 Sep 2014 17:32:29 GMT

Is there a way we can stop reports from reloading for every selection. I mean can we make all the selections first and then click a button (just a thought!) to activate the filters so that the report is filtered for those selections instead of the report running each and ever time I make a small selection.

Thanks

Re: Button to activate the list box selections

jaimeaguilar — Wed, 10 Sep 2014 17:36:11 GMT

Hi,

you can set calculation condition to the tables you need to restrict depending on the filters.

The calculation condition could be something like this:

getSelectedCount(YourField) > 0 or any other expression that helps you restricting the calculation of the table unless some criteria is fullfiled,

regards

Re: Button to activate the list box selections

Wed, 10 Sep 2014 17:58:29 GMT

I mean, I have 10 list boxes. When I start making selections from them, the report is processed for every selection I make. I have large data volume and I have to wait for 6-8 sec after each selection. So, I was wondering if there is any option where I can all the selections at once then have the report processed. Thanks for your response.

Re: Re: Button to activate the list box selections

jaimeaguilar — Wed, 10 Sep 2014 18:30:11 GMT

Yeah, I 've been there. Sometimes, it's really annoying that QV recalculates objects after every minimal selection or even just by moving objects. The problem is that sometimes even objects/tables that are not related to your selections get recalculated.

A possible workaround that I can think of is to create a button that shows/hide your objects and this button gets activated until some/all needed selection are made,

I attached an example,

regards

Re: Re: Re: Button to activate the list box selections

Wed, 10 Sep 2014 19:39:52 GMT

I tried creating a button to attach the report and calculate then detach again. Attached is the sample.

Thanks