topic Re: Adding Input Box values to field results in a bar chart in QlikView

Adding Input Box values to field results in a bar chart

EGilbert — Mon, 30 Mar 2020 17:25:32 GMT

I am attempting to create a what-if comparison dashboard and i am using alternate states to be able to have the same chart shown twice and one of the charts react to selections made in sheet. The charts track factories and total demand and show their open capacity and utilization. i would like to use input boxes to be able to enter a demand value and assign a plant and see how it impacts utilization and open capacity. How can I update the demand field with the values from the input field. The data is all proprietary so I cannot post an example but assume i have a dimensions called plant and platform. The chart is organized by plant and is in a stacked bar chart stacked by platform with the sum of field demand being the expression of values. I have an input box with a variable of DEMIncrease and i want to add values to that to increase the demand in the charts. I also have an input box with a variable called Plantincrease that lists available plants so you can select which plant to add the demand to.

Any help would be appreciated

Re: Adding Input Box values to field results in a bar chart

EGilbert — Tue, 31 Mar 2020 14:04:53 GMT

I created a sample data set. I would like to select a plant from the 'Plant' input box and enter an amount to add in the 'Amount' Input box and update the chart to see the impact

Re: Adding Input Box values to field results in a bar chart

Brett_Bleess — Wed, 22 Apr 2020 20:19:36 GMT

Have a look at the following Design Blog post, hopefully that may be what you need to get you on the right track with things.

https://community.qlik.com/t5/Qlik-Design-Blog/Loading-Data-into-Input-Boxes/ba-p/1469453

Regards,
Brett