topic Problems in Line Charts in QlikView https://community.qlik.com/t5/QlikView/Problems-in-Line-Charts/m-p/1335564#M411970 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have created a Line chart, I have these variables there:</P><P>X= Is the quantity of cases opened during this month</P><P>Y= is the quantity of these cases that were closed</P><P></P><P>The value that will be displayed in the line chart is the Y divided by X to know the percentage of cases closed against opened cases.</P><P></P><P>The problem that I found is that for some months the cases opened is lower than the cases closed. This is possible because I am displaying the data per months. So, I have that on July there are 30 cases opened, but this exact month we closed 45 cases from other months. The result will be = 45/30 = 1.5 in percentage will be 150% and that's not the problem.</P><P></P><P>The problem is that the values on the line chart became crazy:</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/170738_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>Do you know what can I change in the chart to display values from 0 to 1000% if necessary but displaying correct and understandable data?</P></BODY></HTML> Wed, 19 Jul 2017 13:10:58 GMT Anonymous 2017-07-19T13:10:58Z Problems in Line Charts https://community.qlik.com/t5/QlikView/Problems-in-Line-Charts/m-p/1335564#M411970 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have created a Line chart, I have these variables there:</P><P>X= Is the quantity of cases opened during this month</P><P>Y= is the quantity of these cases that were closed</P><P></P><P>The value that will be displayed in the line chart is the Y divided by X to know the percentage of cases closed against opened cases.</P><P></P><P>The problem that I found is that for some months the cases opened is lower than the cases closed. This is possible because I am displaying the data per months. So, I have that on July there are 30 cases opened, but this exact month we closed 45 cases from other months. The result will be = 45/30 = 1.5 in percentage will be 150% and that's not the problem.</P><P></P><P>The problem is that the values on the line chart became crazy:</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/170738_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>Do you know what can I change in the chart to display values from 0 to 1000% if necessary but displaying correct and understandable data?</P></BODY></HTML> Wed, 19 Jul 2017 13:10:58 GMT https://community.qlik.com/t5/QlikView/Problems-in-Line-Charts/m-p/1335564#M411970 Anonymous 2017-07-19T13:10:58Z