Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Need one help

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

1 Solution

Accepted Solutions
Highlighted
Master III
Master III

6 Replies
Highlighted
Master III
Master III

Highlighted
Not applicable

Hi

Try like below,

LOAD Code_Type,

     Name,

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

Highlighted
MVP & Luminary
MVP & Luminary

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

Highlighted
Master II
Master II

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

Highlighted
MVP & Luminary
MVP & Luminary

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.

Highlighted
Master III
Master III

you are right Jagan

Thanks for the information