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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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