topic Re: Actual vs Budget in QlikView

Actual vs Budget

Anonymous — Thu, 29 Nov 2012 05:59:18 GMT

Hi All,

Please help me in solving the below scenario,

Sample data format:

Month,Actual,Budget

Jan,10,10

Feb,20,12

Mar,30,32

Apr,40,41

May,50,52

Jun,60,61

Jul,70,72

Aug,,66

Sep,,77

Oct,,88

Nov,,99

Dec,,88

Scneraio : 1) Actual data is upto jul month and budget data is upto dec month, i want to show the actual and budget value upto jul month not considering the budget data from aug to dec in a straight table

Scneraio : 2) want to get accumlated value , example if i select mar month in a list box, straight table should show data actual and budget value for

jan,feb and mar value

thks in advance

Re: Actual vs Budget

jvitantonio — Thu, 29 Nov 2012 10:16:47 GMT

Hi, please see the example attached.

Re: Actual vs Budget

Gysbert_Wassenaar — Thu, 29 Nov 2012 10:43:59 GMT

See attached example

Re: Actual vs Budget

Anonymous — Thu, 29 Nov 2012 11:06:55 GMT

Hi,

Thanks a lot for both of you guys, it worked

Re: Actual vs Budget

jvitantonio — Thu, 29 Nov 2012 11:09:29 GMT

Please mark the post as correct or helpful.