https://community.qlik.com/t5/App-Development/Below-with-total-and-dimension/m-p/1906092#M74699 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/165038">@LinusNandin</a>&nbsp;</P> <P>Please find the QVF below:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Iswarya__0-1647443593048.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/74642i52D9C566D019775D/image-size/medium?v=v2&amp;px=400" role="button" title="Iswarya__0-1647443593048.png" alt="Iswarya__0-1647443593048.png" /></span></P> <P>&nbsp;</P> Wed, 16 Mar 2022 15:13:53 GMT Iswarya_ 2022-03-16T15:13:53Z https://community.qlik.com/t5/App-Development/Below-with-total-and-dimension/m-p/1905873#M74674 <P>Im trying to get the previsions value which belong to a specific dimension: This is in a table.<BR /><BR />The function</P> <P>Below(Total &lt;App name&gt; [Critical Service Period]) Does not seem to work<BR /><BR />Anyone have an idea how to solve this ?</P> <P>&nbsp;</P> <P>&nbsp; &nbsp;</P> Wed, 16 Mar 2022 09:45:24 GMT https://community.qlik.com/t5/App-Development/Below-with-total-and-dimension/m-p/1905873#M74674 LinusNandin 2022-03-16T09:45:24Z https://community.qlik.com/t5/App-Development/Below-with-total-and-dimension/m-p/1905883#M74675 <P>Can you please share some sample data and the expected output</P> Wed, 16 Mar 2022 09:58:37 GMT https://community.qlik.com/t5/App-Development/Below-with-total-and-dimension/m-p/1905883#M74675 Iswarya_ 2022-03-16T09:58:37Z https://community.qlik.com/t5/App-Development/Below-with-total-and-dimension/m-p/1905900#M74678 <P>&nbsp;</P> <P>This is what I want</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="LinusNandin_0-1647425339083.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/74604iA28A5E197002EB88/image-size/medium?v=v2&amp;px=400" role="button" title="LinusNandin_0-1647425339083.png" alt="LinusNandin_0-1647425339083.png" /></span></P> <P>This is what it is like now</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="LinusNandin_1-1647425393863.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/74605iD7414C9A002388E8/image-size/medium?v=v2&amp;px=400" role="button" title="LinusNandin_1-1647425393863.png" alt="LinusNandin_1-1647425393863.png" /></span></P> <P>Ive also tried</P> <P>FirstSortedValue(Total &lt;App Name&gt; Score,&nbsp; -Last Change, 2)</P> <P><BR />This would work if only it looked at rows where Last change is equal or less than Last Change for the row which is being evaluated</P> Wed, 16 Mar 2022 10:16:07 GMT https://community.qlik.com/t5/App-Development/Below-with-total-and-dimension/m-p/1905900#M74678 LinusNandin 2022-03-16T10:16:07Z https://community.qlik.com/t5/App-Development/Below-with-total-and-dimension/m-p/1905902#M74679 <P>PostAbove <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Wed, 16 Mar 2022 10:11:04 GMT https://community.qlik.com/t5/App-Development/Below-with-total-and-dimension/m-p/1905902#M74679 LinusNandin 2022-03-16T10:11:04Z https://community.qlik.com/t5/App-Development/Below-with-total-and-dimension/m-p/1906092#M74699 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/165038">@LinusNandin</a>&nbsp;</P> <P>Please find the QVF below:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Iswarya__0-1647443593048.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/74642i52D9C566D019775D/image-size/medium?v=v2&amp;px=400" role="button" title="Iswarya__0-1647443593048.png" alt="Iswarya__0-1647443593048.png" /></span></P> <P>&nbsp;</P> Wed, 16 Mar 2022 15:13:53 GMT https://community.qlik.com/t5/App-Development/Below-with-total-and-dimension/m-p/1906092#M74699 Iswarya_ 2022-03-16T15:13:53Z