<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: helped needed on this challenge doing analitycs with strings in variables in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/helped-needed-on-this-challenge-doing-analitycs-with-strings-in/m-p/1614460#M445343</link>
    <description>&lt;P&gt;&amp;nbsp;after some tests, I found how to do it.&amp;nbsp; I want to share it (a little bit tricky but worked!!!) for those who face the same challenge&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2019-08-20_14-21-17.jpg" style="width: 999px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/17381i6A6DDA6F6C59A671/image-size/large?v=v2&amp;amp;px=999" role="button" title="2019-08-20_14-21-17.jpg" alt="2019-08-20_14-21-17.jpg" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Tue, 20 Aug 2019 18:27:30 GMT</pubDate>
    <dc:creator>hectorgarcia</dc:creator>
    <dc:date>2019-08-20T18:27:30Z</dc:date>
    <item>
      <title>helped needed on this challenge doing analitycs with strings in variables</title>
      <link>https://community.qlik.com/t5/QlikView/helped-needed-on-this-challenge-doing-analitycs-with-strings-in/m-p/1614417#M445342</link>
      <description>&lt;P&gt;Good Morning , I'm stuck with this challenge&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have 3 variables&amp;nbsp; and I need:&lt;/P&gt;&lt;P&gt;1) Identify the highest Value in&amp;nbsp;vConcatwrp and then..&lt;/P&gt;&lt;P&gt;2) identify the corresponding value in vIps and&amp;nbsp;vFechas variables.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;for the example below the highest value in&amp;nbsp;vConcatwrp is 302,&amp;nbsp;&lt;/P&gt;&lt;P&gt;(I solved this replacing the '|' by ',' and then rangemax($(vConcatwrp)))&lt;/P&gt;&lt;P&gt;now i need to identfy the corresponding IP for that value in the vIps variable =&amp;nbsp; should be&amp;nbsp;&lt;STRONG&gt;90.130.67&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;and the corresponding value in the vFechas Variable = should be&amp;nbsp;&lt;STRONG&gt;2018-12-28_190.130.67&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;any contribution?&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Thanks&lt;/STRONG&gt;&lt;/P&gt;&lt;TABLE&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD&gt;Variable Name&lt;/TD&gt;&lt;TD&gt;Data&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;vConcatwrp&lt;/TD&gt;&lt;TD&gt;248|618|196|7|302|0&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;vIps&lt;/TD&gt;&lt;TD&gt;190.130.106|190.242.73|186.114.15|191.156.8|190.130.67|191.95.32&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;vFechas&lt;/TD&gt;&lt;TD&gt;2018-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&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;</description>
      <pubDate>Tue, 20 Aug 2019 15:54:20 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/helped-needed-on-this-challenge-doing-analitycs-with-strings-in/m-p/1614417#M445342</guid>
      <dc:creator>hectorgarcia</dc:creator>
      <dc:date>2019-08-20T15:54:20Z</dc:date>
    </item>
    <item>
      <title>Re: helped needed on this challenge doing analitycs with strings in variables</title>
      <link>https://community.qlik.com/t5/QlikView/helped-needed-on-this-challenge-doing-analitycs-with-strings-in/m-p/1614460#M445343</link>
      <description>&lt;P&gt;&amp;nbsp;after some tests, I found how to do it.&amp;nbsp; I want to share it (a little bit tricky but worked!!!) for those who face the same challenge&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2019-08-20_14-21-17.jpg" style="width: 999px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/17381i6A6DDA6F6C59A671/image-size/large?v=v2&amp;amp;px=999" role="button" title="2019-08-20_14-21-17.jpg" alt="2019-08-20_14-21-17.jpg" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 20 Aug 2019 18:27:30 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/helped-needed-on-this-challenge-doing-analitycs-with-strings-in/m-p/1614460#M445343</guid>
      <dc:creator>hectorgarcia</dc:creator>
      <dc:date>2019-08-20T18:27:30Z</dc:date>
    </item>
  </channel>
</rss>

