topic Re: String function issue in QlikView

String function issue

Mon, 08 Aug 2011 14:51:18 GMT

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

String function issue

its_anandrjs — Mon, 08 Aug 2011 15:12:27 GMT

Hi Merwan,

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

Regards,

Anand

String function issue

SunilChauhan — Mon, 08 Aug 2011 15:19:12 GMT

I belieeve u have copleted all the thinks

your application is enough to providorde your result accordingly

Please see the attach for reference

Re: String function issue

SunilChauhan — Mon, 08 Aug 2011 15:19:57 GMT

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

String function issue

Mon, 08 Aug 2011 15:20:29 GMT

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

String function issue

Mon, 08 Aug 2011 15:20:46 GMT

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

Re: String function issue

its_anandrjs — Mon, 08 Aug 2011 15:33:51 GMT

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

String function issue

Mon, 08 Aug 2011 15:44:58 GMT

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

Re: String function issue

SunilChauhan — Mon, 08 Aug 2011 16:20:28 GMT

see the attached might help u

String function issue

Mon, 08 Aug 2011 21:07:38 GMT

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