topic Re: Need one help in QlikView

Need one help

nagarjuna_kotha — Mon, 24 Aug 2015 06:16:44 GMT

Hi all,

I have one Field "Code_Type" , in that i have a value 10.But what i want is instead of 10 i want "Country".Can any one help me how to get that ?

thanks in Advance

Naga

Re: Need one help

arulsettu — Mon, 24 Aug 2015 06:22:48 GMT

like this

Re: Need one help

Mon, 24 Aug 2015 06:23:22 GMT

Try like below,

LOAD Code_Type,

Name,

if(wildmatch(Country,'10'),'Country') as NewCountry

Re: Need one help

jagan — Mon, 24 Aug 2015 06:23:43 GMT

Hi,

Change your script below, now country values are displaying in the Code_Type field.

LOAD Country AS Code_Type,

Name,

Country

FROM

(ooxml, embedded labels, table is Sheet1);

Re: Need one help

qlikviewwizard — Mon, 24 Aug 2015 06:33:12 GMT

Hi,

Please check this.

Hope this will help you.

Country:

LOAD * ,

if(wildmatch(Code_Type,'10'),Country) as Country_New;

LOAD Code_Type,

Country,

Name

FROM

[Country_NeedHelp.xls]

(biff, embedded labels, table is Sheet1$);

Re: Need one help

jagan — Mon, 24 Aug 2015 06:59:30 GMT

Hi Arul,

It is not a good practice to use calculated expression in List boxes, arrive a new column in script like below otherwise you will have performance issues or you need to hardcode in multiple places, it is difficult to maintain the changes in multiple places.

LOAD

if(Code_Type='10','Country') AS NewFieldName

FROM DataSource;

Regards,

Jagan.

Re: Need one help

arulsettu — Mon, 24 Aug 2015 07:01:32 GMT

you are right Jagan

Thanks for the information