Summing over a range of values specified by index values
Hi everyone,
I'm new to Qliksense, but I think it's time to ask some experts for help after I've spent literally 2 days trying to do something so utterly simple. I have a table of 2 numbers, "Financial_Month", with values from 1 to 12 and "Budget_Each_Month". Our financial year starts October, so I wrote a variable to convert the current month to the current financial month, called "Current_Month".
Now, I'm wanting a simple method of returning a single number of the sum of Budget_Each_Month from Financial_Month=1 to the Current_Month, and also to the Current_Month-1.
This returns 0 in a KPI I set up just for testing. Of course, how it knows what the CURRENT line is, is anybody's guess. Nowhere can I fond any info on that.
Closest I got was this:
Sum({$<Financial_Month={"< 7"}>} Training_Budget)
Where 7 was the current month. However, I cannot insert the variable Current Month in without Qliksense throwing an error. I've tried removing quotes, trying single quotes, nothing seems to work. Please help!
