topic Pivot column sum + first sorted value problem in QlikView https://community.qlik.com/t5/QlikView/Pivot-column-sum-first-sorted-value-problem/m-p/254365#M581848 <HTML><HEAD></HEAD><BODY><P>Solved it by enclosing the expression with sum(aggr(EXPRESSION, dimension)), a good read that reference manual ...</P></BODY></HTML> Thu, 24 Nov 2011 18:38:41 GMT 2011-11-24T18:38:41Z Pivot column sum + first sorted value problem https://community.qlik.com/t5/QlikView/Pivot-column-sum-first-sorted-value-problem/m-p/254364#M581847 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P>Firstsortedvalue({&lt;EXECUTION_DATE={"&lt;=$(=max(Date))"}&gt;} NoRunFlag, -RUN_ID)</P><P></P><P>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?</P><P></P><P>Thanks,</P><P></P><P>Fredrik</P></BODY></HTML> Thu, 24 Nov 2011 15:04:49 GMT https://community.qlik.com/t5/QlikView/Pivot-column-sum-first-sorted-value-problem/m-p/254364#M581847 2011-11-24T15:04:49Z Pivot column sum + first sorted value problem https://community.qlik.com/t5/QlikView/Pivot-column-sum-first-sorted-value-problem/m-p/254365#M581848 <HTML><HEAD></HEAD><BODY><P>Solved it by enclosing the expression with sum(aggr(EXPRESSION, dimension)), a good read that reference manual ...</P></BODY></HTML> Thu, 24 Nov 2011 18:38:41 GMT https://community.qlik.com/t5/QlikView/Pivot-column-sum-first-sorted-value-problem/m-p/254365#M581848 2011-11-24T18:38:41Z