Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Strucked with sub totals in Pivot table on months

Hi All,

I am new to QlikView , PFA

the Issue is when i clik on paricular month it is showing SUM of allocation value for the particular month but when i am selecting all the the months  the sum of Allocation Value is Not coming  for the months'


Can any one help on these,

Regards,

Sruthi Reddy

1 Solution

Accepted Solutions
Highlighted
Master
Master

Hi,

add month in your expression:sum(aggr(AVG(ALLOC_VAL),PRJ_NM,RSRC_NM,month))/8

View solution in original post

1 Reply
Highlighted
Master
Master

Hi,

add month in your expression:sum(aggr(AVG(ALLOC_VAL),PRJ_NM,RSRC_NM,month))/8

View solution in original post