Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Aitelli_805
Contributor II
Contributor II

Compare 3 values in straight table

I have a  Straight table and in that table, I have multiple dimensions to compare. These comparison are sap serial, device, code. would like to make a column  to show the serial which doesn't match and match and user would be able to look up to select the serial number match ore not match.  Any suggestion would appreciate.

LocationNamegridstatussapserialdevicecodeAsset
NJIsabel12installed345698983456121234
NYMarc14installed78910787878910145678
NYCat18installed233323332333111223
        

 

6 Replies
fosuzuki
Partner - Specialist III
Partner - Specialist III

Match the serial with what???

Arslan_Ahmed
Contributor II
Contributor II


A:
LOAD * INLINE [
Location, Name, grid, status, sapserial, device, code, asset
NJ, Isabel, 12, installed, 3456, 9898, 3456, 121234
NY, Marc, 14, installed, 78910, 7878, 78910, 145678
NY, Cat, 18, installed, 2333, 2333, 2333, 111223
];

B:
Load * , if(sapserial = code , 'True','False') As Match_Field Resident A;

Drop Table A;

Saravanan_Desingh

Can you show the expected output? I could not understand completely.

Aitelli_805
Contributor II
Contributor II
Author

I'm trying to compare these three data points sapserial, device, code. Another column to show the serial across where they're match or mismatch.  I tried the below formula but when I selected for mismatch still show the serial match. 

=if(sapserial<>device],'Mismatch','Match',)

Aitelli_805
Contributor II
Contributor II
Author

I'm trying to compare these three data points sapserial, device, code. Another column to show the serial across where they're match or mismatch.  I tried the below formula but when I selected for mismatch still show the serial match. 

=if(sapserial<>device],'Mismatch','Match',)

fosuzuki
Partner - Specialist III
Partner - Specialist III

In your data load, create a column with this:

if(sapserial=device and device=code,'Match','Mismatch') AS Check

By doing this, you will be able to use this column as a filter.