String function issue

[#1]

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

Meher

[its_anandrjs]

Hi Merwan,

Which values of US and India you want to store on the variable. Please provide details.

Regards,

Anand

[SunilChauhan]

I belieeve u have copleted all the thinks

your application is enough to providorde your result accordingly

Please see the attach for reference

[SunilChauhan]

I belieeve u have copleted all the thinks

your application is enough to providorde your result accordingly

Please see the attach for reference,

if select multiples then it will show the result

[#5]

Hi Anand ,

I want to store US & India into 2 different variables so that i can use my math conditions on them for sales & etc.

Thankyou

Meher

[#6]

I don't understand Why dont you try to load a State an country in a separate Tables, thats simplify the job.

Here You Have an Example:

StateCountry:

LOAD country,

     State

FROM

(ooxml, embedded labels, table is Sheet1);

Sales:

LOAD Name,

     Department,

     State,

     CNT,

     Sales

FROM

(ooxml, embedded labels, table is Sheet1);

[its_anandrjs]

Hi Merwen,

If you make a resident table to get Sum of India and US sales and then you able to use that values for calculation.

By creating Resident table by below code.

load

Sum(If(country='US',Sales)) as USSales,

Sum(If(country='IND',Sales)) as INDSales

Resident Main;

Regards,

Anand

[#8]

Thanks for the suggestions but these didn't worked for me

I want to use two  different countries in expressions ( set analysis )

so i want to spit them & i want to save them in two different variables .

Thanks

Meher

[SunilChauhan]

see the attached might help u

[#10]

Hi sunil

thanks for ur help but it's not working when i'm selecting UK/Aus & the data is a sample data I can't hardcode set analysis

thankyou

Meher