Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
vijetasharma
Contributor III

Unmatched values problem

Hi,

I want to display unmatched field values from second table where in first table they are present which function should I use?Lookup or applymap?

1 Solution

Accepted Solutions
sundarakumar
Valued Contributor II

Re: Unmatched values problem

Use Not exists in load script.

-Sundar

5 Replies
sundarakumar
Valued Contributor II

Re: Unmatched values problem

Use Not exists in load script.

-Sundar

amit_saini
Honored Contributor III

Re: Unmatched values problem

Hi Vijeta,

This can be acheived by Lkup function . Please see the attachment below.

Thanks,

AS

sundarakumar
Valued Contributor II

Re: Re: Unmatched values problem

Hi,

PFA example of Not eists.

-Sundar

vijetasharma
Contributor III

Re: Unmatched values problem

Thanks,not exists function is working fine

sundarakumar
Valued Contributor II

Re: Unmatched values problem

You are welcome. Please Close the thread once u r done.

U can close it by marking the correct answer.

Community Browser