https://community.qlik.com/t5/App-Development/line-graph-with-several-month-measures-Y-axe-s/m-p/1854286#M70524 <P>Hello folks,</P> <P>I am trying to achieve the following :&nbsp;</P> <P>I needed to create column measures per exemple for each month of sales i have a column in my DB</P> <P>I made it like this due to performance issue, if i dont i will have 1line X 36 wich brings 720M rows instead of 20M</P> <P>I achieved what i wanted in the pivot table bellow, but when i do try to make a line graph it became tricky since i do have 36 measures and each one for a month</P> <P>What i could do its Month in colors and years in the Y axe's</P> <P>what i need its the month in the Y axes and years in colors</P> <P>: Thanks for your help</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="bentley32_1-1635778045824.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/65716i2ACF839E50540785/image-size/medium?v=v2&amp;px=400" role="button" title="bentley32_1-1635778045824.png" alt="bentley32_1-1635778045824.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 01 Nov 2021 14:56:37 GMT bentley32 2021-11-01T14:56:37Z https://community.qlik.com/t5/App-Development/line-graph-with-several-month-measures-Y-axe-s/m-p/1854286#M70524 <P>Hello folks,</P> <P>I am trying to achieve the following :&nbsp;</P> <P>I needed to create column measures per exemple for each month of sales i have a column in my DB</P> <P>I made it like this due to performance issue, if i dont i will have 1line X 36 wich brings 720M rows instead of 20M</P> <P>I achieved what i wanted in the pivot table bellow, but when i do try to make a line graph it became tricky since i do have 36 measures and each one for a month</P> <P>What i could do its Month in colors and years in the Y axe's</P> <P>what i need its the month in the Y axes and years in colors</P> <P>: Thanks for your help</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="bentley32_1-1635778045824.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/65716i2ACF839E50540785/image-size/medium?v=v2&amp;px=400" role="button" title="bentley32_1-1635778045824.png" alt="bentley32_1-1635778045824.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 01 Nov 2021 14:56:37 GMT https://community.qlik.com/t5/App-Development/line-graph-with-several-month-measures-Y-axe-s/m-p/1854286#M70524 bentley32 2021-11-01T14:56:37Z https://community.qlik.com/t5/App-Development/line-graph-with-several-month-measures-Y-axe-s/m-p/1854382#M70532 <P>Some one ? <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Mon, 01 Nov 2021 18:46:42 GMT https://community.qlik.com/t5/App-Development/line-graph-with-several-month-measures-Y-axe-s/m-p/1854382#M70532 bentley32 2021-11-01T18:46:42Z