Input Problem

[#1]

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

[Oleg_Troyansky]

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

[#3]

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

[Oleg_Troyansky · Accepted solution]

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

[#5]

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

[#6]

Hi

thanks, i get your idea.

it solve my problem perfectly