topic Selecting data from Range of columns in QlikView https://community.qlik.com/t5/QlikView/Selecting-data-from-Range-of-columns/m-p/1587857#M738456 <P>Hi,</P><P>I am trying to get values within range&nbsp; from below table</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>&nbsp;</TD><TD>Site1</TD><TD>Site2</TD><TD>Site3</TD><TD>Site4</TD><TD>Site5</TD><TD>Site6</TD></TR><TR><TD>City1</TD><TD>556.6862</TD><TD>281.4253</TD><TD>394.1862</TD><TD>207.4911</TD><TD>1313.492</TD><TD>523.6804</TD></TR><TR><TD>City2</TD><TD>561.1425</TD><TD>286.2486</TD><TD>398.0048</TD><TD>209.8744</TD><TD>1316.507</TD><TD>520.5825</TD></TR><TR><TD>City3</TD><TD>548.1638</TD><TD>277.3482</TD><TD>399.6847</TD><TD>193.9866</TD><TD>1300.695</TD><TD>515.9695</TD></TR><TR><TD>City4</TD><TD>558.8382</TD><TD>283.7867</TD><TD>396.1085</TD><TD>208.5752</TD><TD>1314.903</TD><TD>522.0923</TD></TR><TR><TD>City5</TD><TD>658.863</TD><TD>586.9552</TD><TD>814.3368</TD><TD>343.7025</TD><TD>1075.604</TD><TD>245.5309</TD></TR><TR><TD>City6</TD><TD>561.9312</TD><TD>284.4052</TD><TD>391.6543</TD><TD>215.2484</TD><TD>1320.906</TD><TD>527.8075</TD></TR><TR><TD>City7</TD><TD>546.524</TD><TD>269.4021</TD><TD>382.9755</TD><TD>204.2632</TD><TD>1308.027</TD><TD>533.6238</TD></TR><TR><TD>City8</TD><TD>655.9647</TD><TD>590.4726</TD><TD>820.0054</TD><TD>348.3954</TD><TD>1063.389</TD><TD>255.7009</TD></TR><TR><TD>City9</TD><TD>660.1665</TD><TD>593.5486</TD><TD>822.5012</TD><TD>351.1468</TD><TD>1066.926</TD><TD>251.583</TD></TR><TR><TD>City10</TD><TD>555.3619</TD><TD>281.2719</TD><TD>396.3016</TD><TD>204.4926</TD><TD>1310.806</TD><TD>521.0639</TD></TR><TR><TD>City11</TD><TD>661.9681</TD><TD>592.3588</TD><TD>820.2817</TD><TD>349.3983</TD><TD>1072.822</TD><TD>246.4592</TD></TR><TR><TD>City12</TD><TD>546.6184</TD><TD>273.6628</TD><TD>393.5157</TD><TD>196.6689</TD><TD>1302.381</TD><TD>522.3088</TD></TR><TR><TD>City13</TD><TD>658.1035</TD><TD>591.6513</TD><TD>820.7714</TD><TD>349.3378</TD><TD>1065.859</TD><TD>253.0866</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Output i am looking for is to list Sites under city , for example i am looking for which site is less then 500 KM from the city, in above case for example, site 4 and site 6 should fall under City 9,site 6 and site 4 should fall under city 13 and so on.&nbsp; i then want to show this table as per Cities with site listing under cities which are less then 500 KM.&nbsp;</P><P>Appreciate if anyone can give any idea? thanks</P> Wed, 25 Nov 2020 16:16:04 GMT AJKhan 2020-11-25T16:16:04Z Selecting data from Range of columns https://community.qlik.com/t5/QlikView/Selecting-data-from-Range-of-columns/m-p/1587857#M738456 <P>Hi,</P><P>I am trying to get values within range&nbsp; from below table</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>&nbsp;</TD><TD>Site1</TD><TD>Site2</TD><TD>Site3</TD><TD>Site4</TD><TD>Site5</TD><TD>Site6</TD></TR><TR><TD>City1</TD><TD>556.6862</TD><TD>281.4253</TD><TD>394.1862</TD><TD>207.4911</TD><TD>1313.492</TD><TD>523.6804</TD></TR><TR><TD>City2</TD><TD>561.1425</TD><TD>286.2486</TD><TD>398.0048</TD><TD>209.8744</TD><TD>1316.507</TD><TD>520.5825</TD></TR><TR><TD>City3</TD><TD>548.1638</TD><TD>277.3482</TD><TD>399.6847</TD><TD>193.9866</TD><TD>1300.695</TD><TD>515.9695</TD></TR><TR><TD>City4</TD><TD>558.8382</TD><TD>283.7867</TD><TD>396.1085</TD><TD>208.5752</TD><TD>1314.903</TD><TD>522.0923</TD></TR><TR><TD>City5</TD><TD>658.863</TD><TD>586.9552</TD><TD>814.3368</TD><TD>343.7025</TD><TD>1075.604</TD><TD>245.5309</TD></TR><TR><TD>City6</TD><TD>561.9312</TD><TD>284.4052</TD><TD>391.6543</TD><TD>215.2484</TD><TD>1320.906</TD><TD>527.8075</TD></TR><TR><TD>City7</TD><TD>546.524</TD><TD>269.4021</TD><TD>382.9755</TD><TD>204.2632</TD><TD>1308.027</TD><TD>533.6238</TD></TR><TR><TD>City8</TD><TD>655.9647</TD><TD>590.4726</TD><TD>820.0054</TD><TD>348.3954</TD><TD>1063.389</TD><TD>255.7009</TD></TR><TR><TD>City9</TD><TD>660.1665</TD><TD>593.5486</TD><TD>822.5012</TD><TD>351.1468</TD><TD>1066.926</TD><TD>251.583</TD></TR><TR><TD>City10</TD><TD>555.3619</TD><TD>281.2719</TD><TD>396.3016</TD><TD>204.4926</TD><TD>1310.806</TD><TD>521.0639</TD></TR><TR><TD>City11</TD><TD>661.9681</TD><TD>592.3588</TD><TD>820.2817</TD><TD>349.3983</TD><TD>1072.822</TD><TD>246.4592</TD></TR><TR><TD>City12</TD><TD>546.6184</TD><TD>273.6628</TD><TD>393.5157</TD><TD>196.6689</TD><TD>1302.381</TD><TD>522.3088</TD></TR><TR><TD>City13</TD><TD>658.1035</TD><TD>591.6513</TD><TD>820.7714</TD><TD>349.3378</TD><TD>1065.859</TD><TD>253.0866</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Output i am looking for is to list Sites under city , for example i am looking for which site is less then 500 KM from the city, in above case for example, site 4 and site 6 should fall under City 9,site 6 and site 4 should fall under city 13 and so on.&nbsp; i then want to show this table as per Cities with site listing under cities which are less then 500 KM.&nbsp;</P><P>Appreciate if anyone can give any idea? thanks</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Selecting-data-from-Range-of-columns/m-p/1587857#M738456 AJKhan 2020-11-25T16:16:04Z Re: Selecting data from Range of columns https://community.qlik.com/t5/QlikView/Selecting-data-from-Range-of-columns/m-p/1587864#M738457 Can you replicate the output table over here rather than o/p description?? Tue, 04 Jun 2019 05:55:16 GMT https://community.qlik.com/t5/QlikView/Selecting-data-from-Range-of-columns/m-p/1587864#M738457 Shubham_Deshmukh 2019-06-04T05:55:16Z Re: Selecting data from Range of columns https://community.qlik.com/t5/QlikView/Selecting-data-from-Range-of-columns/m-p/1588569#M738458 <P>Hi thanks for your reply, output representation i&nbsp; am after is like this</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Output</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>City 9</TD><TD>City 3</TD></TR><TR><TD>Site 4</TD><TD>Site 3</TD></TR><TR><TD>Site 6</TD><TD>Site 4</TD></TR><TR><TD>&nbsp;</TD><TD>Site 5</TD></TR></TBODY></TABLE> Wed, 05 Jun 2019 11:52:35 GMT https://community.qlik.com/t5/QlikView/Selecting-data-from-Range-of-columns/m-p/1588569#M738458 AJKhan 2019-06-05T11:52:35Z