https://community.qlik.com/t5/App-Development/Pivot-Table-reflect-the-latest-value-in-a-dimension/m-p/2112779#M90878 <P>anyone got any ideas here?</P> Mon, 04 Sep 2023 09:08:06 GMT fishing_weights 2023-09-04T09:08:06Z https://community.qlik.com/t5/App-Development/Pivot-Table-reflect-the-latest-value-in-a-dimension/m-p/2112379#M90863 <P>In continuation of:&nbsp;<A href="https://community.qlik.com/t5/App-Development/Qlikview-Pivot-and-flag/m-p/2111634#M90808" target="_self">Qlikview-Pivot-and-flag</A>&nbsp;</P> <P>I've a pivot table with grouping in the expression and partial sum for the dimension.</P> <P>&nbsp;</P> <P>How do i get a dimension to reflect the latest value base on the date selected?</P> <P>I've tried:</P> <P>FirstSortedValue and Max in the dimension but both does not solve the issue.</P> <P>attached is the sample data and the QVW sample. Thanks in advance</P> Fri, 15 Nov 2024 21:26:11 GMT https://community.qlik.com/t5/App-Development/Pivot-Table-reflect-the-latest-value-in-a-dimension/m-p/2112379#M90863 fishing_weights 2024-11-15T21:26:11Z https://community.qlik.com/t5/App-Development/Pivot-Table-reflect-the-latest-value-in-a-dimension/m-p/2112779#M90878 <P>anyone got any ideas here?</P> Mon, 04 Sep 2023 09:08:06 GMT https://community.qlik.com/t5/App-Development/Pivot-Table-reflect-the-latest-value-in-a-dimension/m-p/2112779#M90878 fishing_weights 2023-09-04T09:08:06Z