Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Using inputsum to calc budget, why is the total budget on pivot table incorrect

I'm using a Pivot Table to generate a budget based on last year’s sales. The user enters a growth % (input field) for each product (each row), the budget column is growth  % to last years sales.

Works ok, except the total of the budget column is incorrect.

Capture.PNG

7,920 * 1.1                  = 8,712        ok      

11,565 * 1.2                = 13,878       ok

Actual Total                = 22,590

Per Table Sum:          23,382         Incorrect

Expressions:

           

Growth %

inputsum(GrowthPC,'*') 

Actual LY

Sum ({$<DataType={'MP_Sales','CG_Sales'},FinYear = {$(vFinYear_LY)}>}$Sales)

Budget

Sum ({$<DataType={'MP_Sales','CG_Sales'},FinYear = {$(vFinYear_LY)}>}$Sales)* (1+Max ({$<xFinYear = {$(vFinYear)}>}GrowthPC)/100)

1 Reply
nagaiank
Valued Contributor III

Using inputsum to calc budget, why is the total budget on pivot table incorrect

In the Chart properties, set the 'Total Mode' to 'Sum of Rows' for Budget expression.

You may also set the 'Total Mode' to 'No Totals' for the 'Growth %' as the total does not convey any meaningful information.

Hope this helps.