Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

How to exclude data using Excel file

Test

Tags (1)
4 Replies
Highlighted
Specialist II
Specialist II

Re: How to exclude data from Excel file

what do you mean by execute ? do you want to load data from excel with some where condition ?

Thanks

BKC

Highlighted
Partner
Partner

Re: How to exclude data from Excel file

Hi,

If you don´t want to load some Investment_Name  from excel, you can use where not exists.

Highlighted
Partner
Partner

Re: How to exclude data from Excel file

Hi Balkumar,

As Federico said i want to exclude this Investment name with respective calendar key which is present in a Excel file..

We can use Where Not Exists function but it not works may be my syntax is incorrect..

Could you please suggest me how to write this where not exits in script if possible.

THanks,

Djadhav

Highlighted
Specialist II
Specialist II

Re: How to exclude data from Excel file

First you need to load your excel into qliview then use that column in where Not Exists()

ex .

A:

Load Name

From Excel1

B:

Load

Name,

Address


from .....table2


where Not Exists(Name)

Note : you should have Name column in both the table

see the example for syntax

Dual & Exists – Useful Functions