topic Re: Problem with Input box in QlikView

Input Problem

Tue, 15 Sep 2015 00:37:55 GMT

Hi,

I have a question,

I have two input box and a data like this:

Anyone has any idea to make the input box not calculate the data automatically when changed and provide a button to calculate the data after user input both input box.

I also provide my sample qvw file.

Thanks

Re: Problem with Input box

Oleg_Troyansky — Tue, 15 Sep 2015 00:47:45 GMT

Add a Calculation Condition to your chart, using a new variable vCalculate:

- every time the user is changing one of the two variables, use triggers and actions to set vCalculate to 0

- Add a button "Calculate" that would set the variable to 1.

Also, would you like to do something with your chart to reduce the calculation time down? Not too many users have patience for 3 minutes waiting time. Let me guess - are you using an AGGR() function with a large number of dimensional values? Or using too many IF() conditions?

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

Re: Problem with Input box

Tue, 15 Sep 2015 01:12:38 GMT

Hi,

thanks it works perfectly.

but is it possible to show the data when i change the percentage. because when i change the percentage the vCalculation set to 0 and show this result:

I still want to show the data when the user change the percentage but not calculate first until the user click the button.

Really need your help.

Thanks

Re: Problem with Input box

Oleg_Troyansky — Tue, 15 Sep 2015 01:26:29 GMT

OK, then you can use another trick...

Define 2 sets of variables - one set to be used for User Input and the other set to be used in your calculations.

The button "Calculate" should transfer the values from the input variables into the calculation variables. This way, the chart will remain static, using the "old" variables until the button Calculate is pressed.

cheers,

Oleg Troyansky

Re: Problem with Input box

Tue, 15 Sep 2015 01:28:39 GMT

Hi,

Thanks for your suggestion, but still don't get the idea.

Would you mind to give me the example please ?

I attach my qvw file here. Thanks

Re: Problem with Input box

Tue, 15 Sep 2015 04:47:41 GMT

thanks, i get your idea.

it solve my problem perfectly