Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hectorgarcia
Partner - Creator III
Partner - Creator III

helped needed on this challenge doing analitycs with strings in variables

Good Morning , I'm stuck with this challenge 

I have 3 variables  and I need:

1) Identify the highest Value in vConcatwrp and then..

2) identify the corresponding value in vIps and vFechas variables.

 

for the example below the highest value in vConcatwrp is 302, 

(I solved this replacing the '|' by ',' and then rangemax($(vConcatwrp)))

now i need to identfy the corresponding IP for that value in the vIps variable =  should be 90.130.67

and the corresponding value in the vFechas Variable = should be 2018-12-28_190.130.67

 

 

any contribution? 

 

Thanks

Variable NameData
vConcatwrp248|618|196|7|302|0
vIps190.130.106|190.242.73|186.114.15|191.156.8|190.130.67|191.95.32
vFechas2018-12-24_190.130.106|2018-12-25_190.242.73|2018-12-27_186.114.15|2018-12-27_191.156.8|2018-12-28_190.130.67|2018-12-29_191.95.32
1 Solution

Accepted Solutions
hectorgarcia
Partner - Creator III
Partner - Creator III
Author

 after some tests, I found how to do it.  I want to share it (a little bit tricky but worked!!!) for those who face the same challenge

 

2019-08-20_14-21-17.jpg

 

 

View solution in original post

1 Reply
hectorgarcia
Partner - Creator III
Partner - Creator III
Author

 after some tests, I found how to do it.  I want to share it (a little bit tricky but worked!!!) for those who face the same challenge

 

2019-08-20_14-21-17.jpg