Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
nrwlafhus
Contributor
Contributor

Pivot Table Totals

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])

January Filter.PNG

January and Cost Center Filter.PNG

2 Replies
amityehoclimber
Contributor III
Contributor III

Try changing the formula into:

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

sunny_talwar

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])