I'm having an issue solving an issue in converting an Excel calculation to my Qlikview dashboard.
Please see the attached image. What I'm trying to do is calculate a ratio based on: C11/(C3+B3). This result for month 09-2012 is the ratio shown in cell B19. For the next month it's D11/(D3+C3) in cell C19 and so on. I want to do this for a range of months from 08-2012 to 09-2014.
This is very easy to do using Excel, but how do I convert this to Qlikview? I want to show these ratios in a line chart as well.
I've already spent all morning trying to figure out how to do this, but I can't seem to figure it out. I've already tried splitting the two calculations (Calc 1, Calc 2) in seperate workbooks and using set analysis and variables containing the 'addmonths' function, but all to no avail.
I'm sorry if I'm supplying too little information; please ask if you need more.
In a straight table, you can reference other columns in an expression using the name of Column() function. The Above() function will get the value from the previous row.
So you could land up with something like:
Column(4)/(Column(3) + Above(Column(3)))
HTH
Jonatham
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
