9 Replies Latest reply: Aug 8, 2011 5:07 PM by bharadwaj pavuluri RSS

    String function issue

      Hello experts ,



      I have two colomns of State & Country .

      I want to auto-select a country if i selects a state , like

      If i select Texas , In state list . In my country list United states have to be selected automatically .

      I'm taking country & state list from excel sheets & I concatenated them both into a link ,

      then i'm using subfield to save them into variables and to display them into separate lists which makes me if i select a state it auto selects country .

      Until now i dont have any issues ,

      I want to display sales in country if they are selecting a state , but if they selects states from different countries how can split them using a string function or anything to display sales in different countries .


      i attached some example excel & qvw's






      Thank you all