Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

=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
sunny_talwar

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)

View solution in original post

5 Replies
paulyeo11
Master
Master
Author

my qvw

sunny_talwar

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)

View solution in original post

Digvijay_Singh
Master III
Master III

something like this -

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

MK_QSL
MVP
MVP

use Match function here..

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

paulyeo11
Master
Master
Author

‌Hi All

thank you every one for your help .

NOw okay

paul