topic expression help in QlikView

expression help

Thu, 24 Jul 2014 08:28:28 GMT

Hi,

Please see app attached.

Need help with the script so it renames certain responses.

'email' needs to be included in EMAIL as this is the correct field. Simiarly 'letter, 'Letter' need to be included in LETTER. 'Phone', 'phone' and 'tel' need to be under PHONE and 'text' needs to be in TEXT.

Appreciate any assistance.

Chris

Re: expression help

sudeepkm — Thu, 24 Jul 2014 08:31:56 GMT

you may use

LOAD upper(Contact) as Contact,

Count

FROM

Re: expression help

israrkhan — Thu, 24 Jul 2014 08:37:33 GMT

see the attachment.

hope it helps..

Re: expression help

Anonymous — Thu, 24 Jul 2014 08:38:15 GMT

Try below,

Upper(Replace(Upper(Contact), 'TEL', 'PHONE'))

Re: Re: expression help

dharmarasu — Thu, 24 Jul 2014 08:39:19 GMT

hi,

see the attachment

Regards,

Dharma

Re: expression help

ashfaq_haseeb — Thu, 24 Jul 2014 08:46:18 GMT

Hi,

May be like this.

Regards

ASHFAQ

Re: expression help

ashfaq_haseeb — Thu, 24 Jul 2014 09:54:15 GMT

Hi Chris.

look at my application With Sadeep and all suggestions

You will not get tel under PHONE as specified below.

'Phone', 'phone' and 'tel' need to be under PHONE

Regards

ASHFAQ