Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
infosense_devel
Contributor II

Calculate "BudgetTarget" Column in table.

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.

target_1.png

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.

1 Solution

Accepted Solutions

Re: Calculate "BudgetTarget" Column in table.

Try this:

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

View solution in original post

2 Replies

Re: Calculate "BudgetTarget" Column in table.

Try this:

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

View solution in original post

infosense_devel
Contributor II

Re: Calculate "BudgetTarget" Column in table.

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