https://community.qlik.com/t5/App-Development/Line-chart/m-p/2510838#M104962 <P>Hi would anyone know how to lay out an excel sheet in order to make a line graph in qlik like the one below where the coloured lines represent the partners.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="GeorgeEard_2-1742477020943.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/178818iE09D4A18DB831EC0/image-size/medium?v=v2&amp;px=400" role="button" title="GeorgeEard_2-1742477020943.png" alt="GeorgeEard_2-1742477020943.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="GeorgeEard_3-1742477175140.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/178820i87100FC114884BB1/image-size/medium?v=v2&amp;px=400" role="button" title="GeorgeEard_3-1742477175140.png" alt="GeorgeEard_3-1742477175140.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Thu, 20 Mar 2025 13:26:47 GMT GeorgeEard 2025-03-20T13:26:47Z https://community.qlik.com/t5/App-Development/Line-chart/m-p/2510838#M104962 <P>Hi would anyone know how to lay out an excel sheet in order to make a line graph in qlik like the one below where the coloured lines represent the partners.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="GeorgeEard_2-1742477020943.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/178818iE09D4A18DB831EC0/image-size/medium?v=v2&amp;px=400" role="button" title="GeorgeEard_2-1742477020943.png" alt="GeorgeEard_2-1742477020943.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="GeorgeEard_3-1742477175140.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/178820i87100FC114884BB1/image-size/medium?v=v2&amp;px=400" role="button" title="GeorgeEard_3-1742477175140.png" alt="GeorgeEard_3-1742477175140.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Thu, 20 Mar 2025 13:26:47 GMT https://community.qlik.com/t5/App-Development/Line-chart/m-p/2510838#M104962 GeorgeEard 2025-03-20T13:26:47Z https://community.qlik.com/t5/App-Development/Line-chart/m-p/2510850#M104964 <P>Hello,</P><P>The simplest solution in your case is to use the crosstable function in Qlik:<BR /><A href="https://help.qlik.com/en-US/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/crosstable.htm?key=69d410072eba4a2f8e69aefb4dc5bdff" target="_blank">https://help.qlik.com/en-US/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/crosstable.htm?key=69d410072eba4a2f8e69aefb4dc5bdff</A></P><P>Then use your Date field as the first dimension and your partner as the second. You will therefore have one row per partner.</P> Thu, 20 Mar 2025 14:26:31 GMT https://community.qlik.com/t5/App-Development/Line-chart/m-p/2510850#M104964 Clement15 2025-03-20T14:26:31Z