Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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

Tags (1)
1 Solution

Accepted Solutions
stabben23
Honored Contributor

Re: Strucked with sub totals in Pivot table on months

Hi,

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

View solution in original post

1 Reply
stabben23
Honored Contributor

Re: Strucked with sub totals in Pivot table on months

Hi,

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

View solution in original post