Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Yaswanth
Contributor
Contributor

Excluding the Values in Base Table based on Other Table Values

Hi,

We have contract numbers in one excel-1And contract numbers with associated values in excel-2

I need some of the contract numbers with associated data in Excel-2 will excluded based on excel-1 contract numbers in qliksense

Regards,

Yaswanth

1 Solution

Accepted Solutions
AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Hello,

You can use exist() to check and take only records maintained in excel 1.

Would be helpful to understand more if you could provide some sample data.

 

Thanks,

Ashutosh

 

View solution in original post

1 Reply
AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Hello,

You can use exist() to check and take only records maintained in excel 1.

Would be helpful to understand more if you could provide some sample data.

 

Thanks,

Ashutosh