topic Re: How to create a new dimension as a calculated field in App Development https://community.qlik.com/t5/App-Development/How-to-create-a-new-dimension-as-a-calculated-field/m-p/2418502#M95424 <P>use Above()</P> <P>= Sales% - Above(Sales%)</P> <P><A href="https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/InterRecordFunctions/above.htm" target="_blank">https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/InterRecordFunctions/above.htm</A></P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 14 Feb 2024 03:07:45 GMT vinieme12 2024-02-14T03:07:45Z How to create a new dimension as a calculated field https://community.qlik.com/t5/App-Development/How-to-create-a-new-dimension-as-a-calculated-field/m-p/2418446#M95420 <P>I have a table that look like this -&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="zztop8970_0-1707853954334.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/159674iBDD8EC1D7489ECF1/image-size/medium?v=v2&amp;px=400" role="button" title="zztop8970_0-1707853954334.png" alt="zztop8970_0-1707853954334.png" /></span></P> <P>&nbsp;</P> <P>I would like to create a new column, Annual growth that would show for each customer how much they grew year-over-yers, i.e get to this state -&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="zztop8970_1-1707854054071.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/159675i96EF17FFBD265677/image-size/medium?v=v2&amp;px=400" role="button" title="zztop8970_1-1707854054071.png" alt="zztop8970_1-1707854054071.png" /></span></P> <P>Is there a Qlik function to do this</P> Tue, 13 Feb 2024 19:56:16 GMT https://community.qlik.com/t5/App-Development/How-to-create-a-new-dimension-as-a-calculated-field/m-p/2418446#M95420 zztop8970 2024-02-13T19:56:16Z Re: How to create a new dimension as a calculated field https://community.qlik.com/t5/App-Development/How-to-create-a-new-dimension-as-a-calculated-field/m-p/2418502#M95424 <P>use Above()</P> <P>= Sales% - Above(Sales%)</P> <P><A href="https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/InterRecordFunctions/above.htm" target="_blank">https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/InterRecordFunctions/above.htm</A></P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 14 Feb 2024 03:07:45 GMT https://community.qlik.com/t5/App-Development/How-to-create-a-new-dimension-as-a-calculated-field/m-p/2418502#M95424 vinieme12 2024-02-14T03:07:45Z