topic Re: Need help on creating Y Axis scale in Grid Chart in QlikView https://community.qlik.com/t5/QlikView/Need-help-on-creating-Y-Axis-scale-in-Grid-Chart/m-p/1320819#M515035 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>If you restricted with grid chart, so you'll have to convert your months from text to numbers and use some hints to calculate the average like:</P><P>avg(val)/max(val)*max(mon)</P><P>,where "mon" is your months converted to 1,2,3 and so on, and "val" is the value per month.</P><P>Why that? PFA below.</P><P></P><P><IMG alt="grid_chart.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/170445_grid_chart.png" style="height: 352px; width: 620px;" /></P></BODY></HTML> Mon, 17 Jul 2017 17:50:24 GMT Sergey_Shuklin 2017-07-17T17:50:24Z Need help on creating Y Axis scale in Grid Chart https://community.qlik.com/t5/QlikView/Need-help-on-creating-Y-Axis-scale-in-Grid-Chart/m-p/1320817#M515033 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I need help on creating a Y -Axis scale in Grid chart in qlikview. Basically My requirement is to display month wise unit price for a particular Item Code.</P><P></P><P>I have attached the screenshot. I need to display the average line in this grid chart. But I am not able to do that as its not allowing me to fix the scale for Unit price.</P><P></P><P>Any ideas/Suggestions?</P></BODY></HTML> Mon, 17 Jul 2017 16:45:23 GMT https://community.qlik.com/t5/QlikView/Need-help-on-creating-Y-Axis-scale-in-Grid-Chart/m-p/1320817#M515033 2017-07-17T16:45:23Z Re: Need help on creating Y Axis scale in Grid Chart https://community.qlik.com/t5/QlikView/Need-help-on-creating-Y-Axis-scale-in-Grid-Chart/m-p/1320818#M515034 <HTML><HEAD></HEAD><BODY><P>Maybe use a double scale chart can help you.</P><P><IMG alt="" class="jive-image image-1" height="183" src="https://community.qlik.com/legacyfs/online/170431_pastedImage_1.png" style="width: 423px; height: 182.617px;" width="423" /></P></BODY></HTML> Mon, 17 Jul 2017 17:17:49 GMT https://community.qlik.com/t5/QlikView/Need-help-on-creating-Y-Axis-scale-in-Grid-Chart/m-p/1320818#M515034 sergio0592 2017-07-17T17:17:49Z Re: Need help on creating Y Axis scale in Grid Chart https://community.qlik.com/t5/QlikView/Need-help-on-creating-Y-Axis-scale-in-Grid-Chart/m-p/1320819#M515035 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>If you restricted with grid chart, so you'll have to convert your months from text to numbers and use some hints to calculate the average like:</P><P>avg(val)/max(val)*max(mon)</P><P>,where "mon" is your months converted to 1,2,3 and so on, and "val" is the value per month.</P><P>Why that? PFA below.</P><P></P><P><IMG alt="grid_chart.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/170445_grid_chart.png" style="height: 352px; width: 620px;" /></P></BODY></HTML> Mon, 17 Jul 2017 17:50:24 GMT https://community.qlik.com/t5/QlikView/Need-help-on-creating-Y-Axis-scale-in-Grid-Chart/m-p/1320819#M515035 Sergey_Shuklin 2017-07-17T17:50:24Z