topic conditional expression in QlikView

conditional expression

Sun, 20 Jul 2014 09:05:21 GMT

i am doing a dashboard to do display statistical data of a budget system.. the months start from Apr to Mar

so as the starting month the cumulative budget (as a example ) should be $100 and for each month $100 should be added so when you come to the Dec month cumulative budget should be $900.

since the present month is Jul the value should be $400.. and if we select Aug the $400 should be displayed without changing to $500 since still we are in the July month..

i am trying to show this in a text box (and $100 is an assumed value there is a variable to define this value call "cum_bud")

i know there should be conditions to check the current month and then to start doing the calculations..

can some one plz help me to create a formula to get the value

will really appreciate the help thank you in advance

Re: conditional expression

Anonymous — Sun, 20 Jul 2014 10:51:09 GMT

Something like this maybe :

= [cum_bud] *

if ( num(month(today())) > 3 ,

num(month(today())) -3 ,

num(month(today())) + 9 )

Re: conditional expression

Sun, 20 Jul 2014 12:39:13 GMT

hi bill

if you don't mind me of asking what is 3 and 9 do??

Re: conditional expression

Anonymous — Sun, 20 Jul 2014 12:49:37 GMT

To cater for for your year starting at Month 4 and ending Month 3 the following year.