topic Re: Chart Expression in QlikView

Chart Expression

Thu, 11 Jul 2013 17:39:49 GMT

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!

Re: Chart Expression

jerem1234 — Thu, 11 Jul 2013 18:09:07 GMT

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.

Re: Chart Expression

Thu, 11 Jul 2013 18:20:47 GMT

Yup, what I've been looking for! Thanks!