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

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

paulyeo11 — Wed, 27 Apr 2016 09:47:49 GMT

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

paulyeo11 — Wed, 27 Apr 2016 09:49:08 GMT

my qvw

sunny_talwar — Wed, 27 Apr 2016 09:50:24 GMT

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 — Wed, 27 Apr 2016 09:51:55 GMT

something like this -

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

MK_QSL — Wed, 27 Apr 2016 09:54:05 GMT

use Match function here..

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

paulyeo11 — Wed, 27 Apr 2016 10:05:38 GMT

‌Hi All

thank you every one for your help .

NOw okay

paul