Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
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
Highlighted

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
Highlighted

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

Highlighted
Contributor II

Re: Calculate "BudgetTarget" Column in table.

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