topic Re: Calculate "BudgetTarget" Column in table. in QlikView

Calculate "BudgetTarget" Column in table.

infosense_devel — Tue, 31 May 2016 13:43:33 GMT

Hello All,

i have scenario in which i have to show "Date", "Budget MTD" and "Target Budget" (final accumulated number of Budget MTD).

Please take a look at below image.

Formula for for "MTD Budget" :-

=Rangesum(above(total sum({<PATH_SELECT =,[Common_Day (#)]=,

REC_TYPE = {'BudgetRec'}>}DAILY_BUDGET*XRATE_CONST*RATE)

,0,rowno(total))

)

Thanks in advance.

sunny_talwar — Tue, 31 May 2016 16:22:32 GMT

Try this:

Sum(TOTAL {<PATH_SELECT =, [Common_Day (#)]=, REC_TYPE = {'BudgetRec'}>} DAILY_BUDGET * XRATE_CONST * RATE)

infosense_devel — Wed, 01 Jun 2016 10:44:12 GMT

Thanks a lot.. it is working exactly what i needed ..