topic Re: Variable Bar Chart based on User Input in App Development

Variable Bar Chart based on User Input

crunyeon — Sat, 16 Nov 2024 06:51:03 GMT

Hello - I am trying to create a cost exploration tool in Qlik Sense that allows a user to enter a yearly cost increase percentage, and view the costs on a bar chart. I attached a sketch of what I'm going for. Each bar represents a year, and when the user enters a cost growth percentage, it cascades down through subsequent years. So, for example, if 2018 cost $100, and the user enters a 10% growth for 2019, 2019 and all following years should start at $110.

Is this possible in Qlik Sense? If so, how can I go about creating it? Thank you for your help!

Re: Variable Bar Chart based on User Input

rbartley — Tue, 15 Jan 2019 15:59:40 GMT

Hi,

Take a look at my response to this question:

https://community.qlik.com/t5/Qlik-Sense-App-Development/Number-of-Months-as-a-Dim/m-p/1530081#M38151

It shows how a variable and an input box can be used and then you can use this variable in the definition of a measure.

Re: Variable Bar Chart based on User Input

crunyeon — Tue, 15 Jan 2019 16:07:55 GMT

Hi Rbartley - thanks for the feedback. Is there a way that a user can define the growth rate for each year, not just an overall growth rate? For example, from 2019-2020 they may input a 6% growth, then from 2020-2021 they may input a 10% growth. Therefore, an overall growth rate for the whole chart will not work.

Re: Variable Bar Chart based on User Input

rbartley — Tue, 15 Jan 2019 16:14:12 GMT

Hi Crunyeon,

Not that I am aware of. They could upload an Excel file into the app with a growth rate against each year, but I don't know any way of allowing them to enter this via the app interface. There might be an extension out there somewhere that does, but I couldn't find one when searching. You'd have to write your own extension.

Re: Variable Bar Chart based on User Input

rbartley — Tue, 15 Jan 2019 16:34:26 GMT

Take a look at the attached app (you'll need to unzip it). It references an Excel file in a folder and when the estimated % is changed and app is re-loaded, the chart and table adjust accordingly.

Re: Variable Bar Chart based on User Input

crunyeon — Tue, 15 Jan 2019 18:14:42 GMT

Thank you for your solution. I was hoping to have something that was fully integrated into Qlik, but I agree that it looks like I am going to have to create an extension for that. I appreciate you taking the time to create an alternative solution for me though.