Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

Meher

9 Replies

String function issue

Hi Merwan,

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

Regards,

Anand

chauhans85
Esteemed Contributor

String function issue

I belieeve u have copleted all the thinks

your application is enough to providorde your result accordingly

Please see the attach for reference

chauhans85
Esteemed Contributor

Re: String function issue

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

Not applicable

String function issue

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

Not applicable

String function issue

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);

Highlighted

Re: String function issue

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

Not applicable

String function issue

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

chauhans85
Esteemed Contributor

Re: String function issue

see the attached might help u

Not applicable

String function issue

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

Community Browser