Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Selecting data from Range of columns

Hi,

I am trying to get values within range  from below table

 Site1Site2Site3Site4Site5Site6
City1556.6862281.4253394.1862207.49111313.492523.6804
City2561.1425286.2486398.0048209.87441316.507520.5825
City3548.1638277.3482399.6847193.98661300.695515.9695
City4558.8382283.7867396.1085208.57521314.903522.0923
City5658.863586.9552814.3368343.70251075.604245.5309
City6561.9312284.4052391.6543215.24841320.906527.8075
City7546.524269.4021382.9755204.26321308.027533.6238
City8655.9647590.4726820.0054348.39541063.389255.7009
City9660.1665593.5486822.5012351.14681066.926251.583
City10555.3619281.2719396.3016204.49261310.806521.0639
City11661.9681592.3588820.2817349.39831072.822246.4592
City12546.6184273.6628393.5157196.66891302.381522.3088
City13658.1035591.6513820.7714349.33781065.859253.0866

 

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.  i then want to show this table as per Cities with site listing under cities which are less then 500 KM. 

Appreciate if anyone can give any idea? thanks

2 Replies
Highlighted
Specialist
Specialist

Re: Selecting data from Range of columns

Can you replicate the output table over here rather than o/p description??
Highlighted
Contributor
Contributor

Re: Selecting data from Range of columns

Hi thanks for your reply, output representation i  am after is like this

Output 
  
City 9City 3
Site 4Site 3
Site 6Site 4
 Site 5