Variable Bar Chart based on User Input

[crunyeon]

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!

[rbartley]

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#M3815...

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.

[crunyeon]

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.

[rbartley]

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.

[rbartley]

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.

[crunyeon]

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.