9 Replies Latest reply: Nov 28, 2016 7:34 AM by Ishu Mehta RSS

    Value Loop and Input Boxes - Create Bar Chart

    Byron Van Wyk

      Hi Guys,


      I am trying to build a qlikview model where there are a few input boxes that the EU can use and will be called later to populate the report. What I wanted to do was chart the values this person has selected for each.


      So what is happening is this. vYear1 = 100, vYear2 = 200 ...vYearN = N..etc. I now want to create a bar chart with Year as the axis.


      In the model is a variable called Financial Year, lets say its 2012, and a variable called modelling years, lets say 5. I have used the function Valueloop to create the dimension


      =ValueLoop(vFinancialYear,vFinancialYear + vModellingYears).... Gives me 2012, 20132, 2014....n etc as my axis. Now how do i call the values from the input boxes and correctly allocate them to the year on the axis.


      I've attached a model that shows what im trying to achieve