topic Re: Define 25% 50% and 75% border values in QlikView https://community.qlik.com/t5/QlikView/Define-25-50-and-75-border-values/m-p/586203#M217537 <HTML><HEAD></HEAD><BODY><P>Requirement is not clear what exact you want ?</P><P>Vikas</P></BODY></HTML> Thu, 30 Jan 2014 09:44:14 GMT vikasmahajan 2014-01-30T09:44:14Z Define 25% 50% and 75% border values https://community.qlik.com/t5/QlikView/Define-25-50-and-75-border-values/m-p/586202#M217536 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>please look at the table:</P><TABLE border="1" class="jiveBorder" height="224" style="border: 1px solid rgb(0, 0, 0); width: 290px; height: 211px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>X</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Y</STRONG></TH></TR><TR><TD style="padding: 2px;">1 </TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">10</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">6</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">16</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">18</TD></TR><TR><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">4</TD></TR><TR><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">8</TD></TR><TR><TD style="padding: 2px;">7</TD><TD style="padding: 2px;">7</TD><TD style="padding: 2px;">14</TD></TR><TR><TD style="padding: 2px;">8</TD><TD style="padding: 2px;">8</TD><TD style="padding: 2px;">12</TD></TR><TR><TD>9</TD><TD></TD><TD>20</TD></TR><TR><TD>10</TD><TD></TD><TD>2</TD></TR></TBODY></TABLE><P></P><P>First i want to order the table by X and then define border for the bottom 25%, the halfway 50% border and the 75% border </P><P>Second i want to order the table by Y and again define these border values.</P><P></P><P>so i want to get three values for X and three for Y:</P><P>x25=2.25</P><P>x50=4.5</P><P>x75=6.75</P><P></P><P>y25=5.5</P><P>y50=11</P><P>y75=16.5</P><P></P><P>how can i derive these values in the script?</P><P>Later on i can use these borders in for instance a gauge meter object.</P><P></P><P>your help would be much appreciated</P><P></P><P>best regards,</P><P>Peter</P></BODY></HTML> Thu, 30 Jan 2014 07:53:37 GMT https://community.qlik.com/t5/QlikView/Define-25-50-and-75-border-values/m-p/586202#M217536 pepe2209 2014-01-30T07:53:37Z Re: Define 25% 50% and 75% border values https://community.qlik.com/t5/QlikView/Define-25-50-and-75-border-values/m-p/586203#M217537 <HTML><HEAD></HEAD><BODY><P>Requirement is not clear what exact you want ?</P><P>Vikas</P></BODY></HTML> Thu, 30 Jan 2014 09:44:14 GMT https://community.qlik.com/t5/QlikView/Define-25-50-and-75-border-values/m-p/586203#M217537 vikasmahajan 2014-01-30T09:44:14Z Re: Define 25% 50% and 75% border values https://community.qlik.com/t5/QlikView/Define-25-50-and-75-border-values/m-p/586204#M217538 <HTML><HEAD></HEAD><BODY><P>sorry </P><P>never mind it is no longer an issue.</P></BODY></HTML> Thu, 30 Jan 2014 09:51:12 GMT https://community.qlik.com/t5/QlikView/Define-25-50-and-75-border-values/m-p/586204#M217538 pepe2209 2014-01-30T09:51:12Z