Discussion Board for collaboration related to QlikView App Development.
what do you mean by execute ? do you want to load data from excel with some where condition ?
If you don´t want to load some Investment_Name from excel, you can use where not exists.
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.
First you need to load your excel into qliview then use that column in where Not Exists()
where Not Exists(Name)
Note : you should have Name column in both the table
see the example for syntax
Dual & Exists – Useful Functions