Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hotui5mmlh05lnl
Contributor
Contributor

How can I add a metric aggregated only by one dimension in a two-dimensional pivot table?

I have a pivot table with two dimensions: POLICY_TYPE and PERIOD.autoCalendar.Year.

I would like to sum, grouping only by PERIOD.autoCalendar.Year.

How do I do it?

I have tried to do:
sum( aggr( sum({<PROGRAM = {'MVS'}>} NET_NEW_POLICIES), [PERIOD.autoCalendar.Year]))

But the total value accumulates only in one of the columns instead of in all, I need that value that appears in column "1" to appear in all columns.

Thank you

Labels (1)
1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

Try

sum( total <[PERIOD.autoCalendar.Year]> NET_NEW_POLICIES )

View solution in original post

1 Reply
hic
Former Employee
Former Employee

Try

sum( total <[PERIOD.autoCalendar.Year]> NET_NEW_POLICIES )