topic Re: Set Expression in QlikView

Set Expression

shamitshah — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Please see attached. I need to add an additional column which will show the year to date Actuals and the remaining Budget. So for

Aug 2017 1925+250=2175

Sept 2017 1925+250+280=2455

Oct 2017 1925+250+280+300=2755

Nov 2107 1925+250+280+300+125=2880

Dec 2017 1925+250+280+300+125+155=3035

Any idea on what the correct expression should be to achieve the above?

Thanks

Re: Set Expression

zhadrakas — Wed, 19 Jul 2017 12:56:49 GMT

see attachment

Re: Set Expression

shamitshah — Wed, 19 Jul 2017 21:41:24 GMT

Hi Tim,

I think there is a misunderstanding. I wanted to get the Actual Year to Date figure + Remaining Accumulated Budget figures in another column. Your expression is accumulating the budget figures.

Thanks

Re: Set Expression

zhadrakas — Thu, 20 Jul 2017 06:24:22 GMT

ok have a look at this.

regards

tim

Re: Set Expression

shamitshah — Thu, 20 Jul 2017 11:20:19 GMT

Thanks Tim,

Works out fine.