Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table - Set Analysis issue

Hi,

I've got an issue with Set Analysis and pivot table

I've got a pivot table as attached

With Dimensions: Month,ID

Value of ID1 supposed to be for example: 25% (383 / 1515)

Value of ID3 supposed to be for example: 60% (917/ 1515)

My problem is to get the total value into the field calculation.

Thanks!

1 Reply
alexandros17
Partner - Champion III
Partner - Champion III

Try

Aggr(Sum(value), Month)