Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

=if(COMPANY='PT.TDS TECHNOLOGY',COMPANY) How to add one more company ?

Hi All

Below expression in Table 1 working fine :-

=if(COMPANY='PT.TDS TECHNOLOGY',COMPANY)

I try to add one more company Table 2 , i get error :-

=if(COMPANY='PT.TDS TECHNOLOGY'&'TDS TECHNOLOGY (KL) SDN BHD',COMPANY)

May i know where i go wrong ?

Paul

1 Solution

Accepted Solutions

Re: =if(COMPANY='PT.TDS TECHNOLOGY',COMPANY) How to add one more company ?

Try this:

=if(Match(COMPANY, 'PT.TDS TECHNOLOGY', 'TDS TECHNOLOGY (KL) SDN BHD'), COMPANY)

or this:

=if(COMPANY = 'PT.TDS TECHNOLOGY' or COMPANY = 'TDS TECHNOLOGY (KL) SDN BHD', COMPANY)

5 Replies
paulyeo11
Valued Contributor II

Re: =if(COMPANY='PT.TDS TECHNOLOGY',COMPANY) How to add one more company ?

my qvw

Re: =if(COMPANY='PT.TDS TECHNOLOGY',COMPANY) How to add one more company ?

Try this:

=if(Match(COMPANY, 'PT.TDS TECHNOLOGY', 'TDS TECHNOLOGY (KL) SDN BHD'), COMPANY)

or this:

=if(COMPANY = 'PT.TDS TECHNOLOGY' or COMPANY = 'TDS TECHNOLOGY (KL) SDN BHD', COMPANY)

Digvijay_Singh
Honored Contributor III

Re: =if(COMPANY='PT.TDS TECHNOLOGY',COMPANY) How to add one more company ?

something like this -

=if(COMPANY='PT.TDS TECHNOLOGY' and COMPANY='TDS TECHNOLOGY (KL) SDN BHD',COMPANY)

Re: =if(COMPANY='PT.TDS TECHNOLOGY',COMPANY) How to add one more company ?

use Match function here..

IF(Match(YourFieldName,'Value1','Value2','Value'3), Result1,Result2)

paulyeo11
Valued Contributor II

Re: =if(COMPANY='PT.TDS TECHNOLOGY',COMPANY) How to add one more company ?

‌Hi All

thank you every one for your help .

NOw okay

paul

Community Browser