topic Re: List out the value give certain range in QlikView https://community.qlik.com/t5/QlikView/List-out-the-value-give-certain-range/m-p/492177#M689706 <HTML><HEAD></HEAD><BODY><P>Anyone can help the above question?</P></BODY></HTML> Tue, 01 Oct 2013 10:36:01 GMT 2013-10-01T10:36:01Z List out the value give certain range https://community.qlik.com/t5/QlikView/List-out-the-value-give-certain-range/m-p/492176#M689705 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Anyone can help on this? Refer to tables below.</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Measurement</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Range1</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Range2</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Range3</TH></TR><TR><TD style="padding: 2px;">AAAA</TD><TD style="padding: 2px;">000-200</TD><TD style="padding: 2px;">6000-7000</TD><TD style="padding: 2px;">80-90</TD></TR><TR><TD style="padding: 2px;">BBBB</TD><TD style="padding: 2px;"><P>111-300</P></TD><TD style="padding: 2px;">8000-9000</TD><TD style="padding: 2px;">60-50</TD></TR><TR><TD style="padding: 2px;">CCCC</TD><TD style="padding: 2px;">200-400</TD><TD style="padding: 2px;">4000-5000</TD><TD style="padding: 2px;"><P>90-100</P></TD></TR></TBODY></TABLE><P></P><P>I would like to list out all the range in row by row as per below table.</P><P></P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Measurement</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Range1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Range2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Range3</STRONG></TH></TR><TR><TD style="padding: 2px;">AAAA</TD><TD style="padding: 2px;">000</TD><TD style="padding: 2px;">6000</TD><TD style="padding: 2px;">80</TD></TR><TR><TD style="padding: 2px;">AAAA</TD><TD style="padding: 2px;">001</TD><TD style="padding: 2px;">6001</TD><TD style="padding: 2px;">81</TD></TR><TR><TD style="padding: 2px;">AAAA</TD><TD style="padding: 2px;">002</TD><TD style="padding: 2px;">6002</TD><TD style="padding: 2px;">82</TD></TR><TR><TD style="padding: 2px;">BBBB</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">CCCC</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">CCCC</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>Would like to list out all the range from 000 till 200 for AAAA and others as well. Any idea?</P><P></P><P>Regards,</P><P>OrangezKhoo</P></BODY></HTML> Mon, 30 Sep 2013 03:06:07 GMT https://community.qlik.com/t5/QlikView/List-out-the-value-give-certain-range/m-p/492176#M689705 2013-09-30T03:06:07Z Re: List out the value give certain range https://community.qlik.com/t5/QlikView/List-out-the-value-give-certain-range/m-p/492177#M689706 <HTML><HEAD></HEAD><BODY><P>Anyone can help the above question?</P></BODY></HTML> Tue, 01 Oct 2013 10:36:01 GMT https://community.qlik.com/t5/QlikView/List-out-the-value-give-certain-range/m-p/492177#M689706 2013-10-01T10:36:01Z