topic Re: Pivot Table Totals in QlikView

Pivot Table Totals

nrwlafhus — Tue, 07 Feb 2017 16:21:27 GMT

I have a pivot table that calculates MTD and YTD. The problem is that the expression total (for YTD) does not respond to selections. For example, when I select January the Grand totals for MTD and YTD are calculating correctly, but when I select a cost center, the MTD will adjust, but the YTD will be frozen. See screen shots below.

The YTD formula I am using is sum( {1<[CLMonthID] = {"<=$(vCLMonthID)"} >} [CL B2017])

Re: Pivot Table Totals

Anonymous — Tue, 07 Feb 2017 16:30:07 GMT

Try changing the formula into:

sum( {$<[CLMonthID] = {"<=$(vCLMonthID)"} >} [CL B2017])

Re: Pivot Table Totals

sunny_talwar — Tue, 07 Feb 2017 16:31:06 GMT

Why do you have 1 in your set expression?

Sum({1<[CLMonthID] = {"<=$(vCLMonthID)"}>} [CL B2017])

May be try without it?

Sum({<[CLMonthID] = {"<=$(vCLMonthID)"}>} [CL B2017])

or allow for selection selection in Cost Center

Sum({1<[CLMonthID] = {"<=$(vCLMonthID)"}, [Cost Center] = $::[Cost Center]>} [CL B2017])