topic Is it possible to use Where and Where exists in single load script ? in App Development

Is it possible to use Where and Where exists in single load script ?

Kaushik2020 — Thu, 13 Apr 2023 07:17:53 GMT

I have a load script where i am using where exists, now if I have to add a where clause - how it can be done ?

Re: Is it possible to use Where and Where exists in single load script ?

marcus_sommer — Thu, 13 Apr 2023 10:40:40 GMT

Maybe something like:

...
where exists(FIELD) and AnotherCondition;

Re: Is it possible to use Where and Where exists in single load script ?

kathrines — Thu, 13 Apr 2023 10:45:49 GMT

Yes, it is possible to use both WHERE and WHERE EXISTS in a single load script in QlikView or Qlik Sense.

The WHERE clause is used to filter data based on a specific condition or set of conditions, while the WHERE EXISTS clause is used to check for the existence of a subquery.

For example, suppose you have two tables named "Sales" and "Customers". You can use the WHERE clause to filter the Sales table based on a specific condition, such as the Sales amount being greater than a certain value:

Re: Is it possible to use Where and Where exists in single load script ?

kathrines — Thu, 13 Apr 2023 10:46:44 GMT

Yes, it is possible to use both WHERE and WHERE EXISTS in a single load script in QlikView or Qlik Sense.

The WHERE clause is used to filter data based on a specific condition or set of conditions, while the WHERE EXISTS clause is used to check for the existence of a subquery.

https://www.reactiontimetest.net/