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: 
Not applicable

Pivot column sum + first sorted value problem

Hi,

I'm using the following expression in a pivot table in order to find the lastest test-result based on a choosen date, which works fine.

Firstsortedvalue({<EXECUTION_DATE={"<=$(=max(Date))"}>} NoRunFlag, -RUN_ID)

However, when choosing several dates the summarization in the pivot table does not work. Say that I have choosen 3 dates, and the flags all return 1, the pivot shows 1 as the column sum instead of 3. Any ideas on how to solve this?

Thanks,

Fredrik

1 Solution

Accepted Solutions
Not applicable
Author

Solved it by enclosing the expression with sum(aggr(EXPRESSION, dimension)), a good read that reference manual ...

View solution in original post

1 Reply
Not applicable
Author

Solved it by enclosing the expression with sum(aggr(EXPRESSION, dimension)), a good read that reference manual ...