topic Re: How to get not equal value in QlikView

How to get not equal value

Fri, 14 Feb 2014 06:38:54 GMT

Hi,

I have two tables.Both tables contains employee id.i want only a mis match value.how to get it

Re: How to get not equal value

vikasmahajan — Fri, 14 Feb 2014 06:48:06 GMT

You can take both data in one excel sheet and cross check using Vlookup function excel

Systax =Vlookup( Search Range,columnno, flag)

This way you can find missing records from table A -> B and vs B-> A also.

Vikas

Re: How to get not equal value

jagan — Fri, 14 Feb 2014 07:13:53 GMT

HI,

Data1:

LOAD

Emp_id,

FROM Data1:

Data2:

LOAD

FROM Data2

WHERE Not Exists(Emp_id);

Now Data2 table has records which are not in Data1 table.

If you are not expecting can you come up with an example and expected output.

Regards,

Jagan.

Re: How to get not equal value

sundarakumar — Fri, 14 Feb 2014 08:27:20 GMT

Hi Mani,

PFA, please specify more details on what you need to achive, so that we can help.

-Sundar

Re: How to get not equal value

hic — Fri, 14 Feb 2014 08:34:58 GMT

You can also make this selection without hard coding stuff in the script.

Right-click on a field from table A, and Select All
Right-click on "employee id", and Select Excluded

Now you have selected the employee id:s that exist in table B but not in A.

HIC

Re: How to get not equal value

Fri, 14 Feb 2014 08:54:06 GMT

In a set Analysys (I think you will get the right answer with all the answers already made):

If you have 2 dimensions not related (data island for ex). Your user has selected Dimension B, but your data is dimensionned by DimensionA:

Sum ({< DimensionA = e(DimensionB) >} DataDimensionnedByA)

If you want to link them (get the same values), use the p() function instead.

Fabrice

Re: How to get not equal value

Fri, 14 Feb 2014 11:03:27 GMT

hi Sundarakumar,

i can't able to load your unmatch.qvw document.Please send your query.I think your source file is correct as my scenario.I want only 10 and 11 values,how to get it

Re: How to get not equal value

sundarakumar — Fri, 14 Feb 2014 11:34:42 GMT

Hi,

PFB

two:

LOAD id
FROM
C:\Users\379790\Desktop\unmatch\src2.xlsx
(ooxml, embedded labels, table is Sheet1);

NoConcatenate
//drop table one;
three:
LOAD id as ida,id
FROM
C:\Users\379790\Desktop\unmatch\src1.xlsx
(ooxml, embedded labels, table is Sheet1);

inner join
four:
LOAD id as id
FROM
C:\Users\379790\Desktop\unmatch\src2.xlsx
(ooxml, embedded labels, table is Sheet1);

-Sundar

Re: How to get not equal value

er_mohit — Fri, 14 Feb 2014 12:11:50 GMT

try this script

TT1:

LOAD * INLINE [

PId1

];

NoConcatenate

TT2:

LOAD PId1 as mismatch, * INLINE [

PId1

]Where not Exists (PId1);

DROP Table TT1;

TT3:

LOAD

* INLINE [

PId1

];

NoConcatenate

TT4:

LOAD PId1 as mismatch, * INLINE [

PId1

]Where not Exists(PId1);

DROP Field PId1;

Re: How to get not equal value

Fri, 14 Feb 2014 12:12:45 GMT

Hi Sundar,

This is helpful but i want the mis match values are load to separate column.how this possible.