Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I started using Qlikview this week and as my first app, I'm trying to create something similar to a burn down chart.
Here's a simplified version of what I'm trying to do:
Max = 15000
Month | Budget |
---|---|
January | Max - Max/6 |
February | January - Max/6 |
March | February - Max/6 |
April | March - Max/6 |
May | April - Max/6 |
June | May - Max/6 |
I only have months as my data; budget is nowhere in my excel file.
I figured I can create a variable for Max.
But I'm just lost on how I would be able to input a different expression for each x value.
Any ideas on how I can get this done without directly adding a column on my excel file?
Thank you so much!
Not exactly sure how you are calculating budget, my understanding from your post is that January would have budget 15000 - 15000/6, then February would have January's budget - 15000/6. With this is mind, try something like:
=Max - num(Month)*(Max/6)
So for January it would be:
15000 - 1*15000/6
February:
15000 - 2*15000/6 = 15000 - 15000/6 - 15000/6
Hope this is what you were looking for. Just make sure Month is in a Date format.
Not exactly sure how you are calculating budget, my understanding from your post is that January would have budget 15000 - 15000/6, then February would have January's budget - 15000/6. With this is mind, try something like:
=Max - num(Month)*(Max/6)
So for January it would be:
15000 - 1*15000/6
February:
15000 - 2*15000/6 = 15000 - 15000/6 - 15000/6
Hope this is what you were looking for. Just make sure Month is in a Date format.
Yup, what I've been looking for! Thanks!