topic Run Qlikview application based on Flag in the database table in QlikView

Run Qlikview application based on Flag in the database table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I would like to run a qlikview application from QMC only if the flag is defined as Yes in the database table.

If (select val from table) returns Yes then

Task successful

Else

Task failed.

Please help.

kaushiknsolanki — Mon, 30 Apr 2018 17:42:06 GMT

Hi,

What you need is an EDX.

So if the condition is true you trigger the task using EDX.

For more info check link below.

Regards,

Kaushik Solanki

sasiparupudi1 — Mon, 30 Apr 2018 18:12:49 GMT

may be try exit when in the load script

connect to your db

T1:

SQL Select flag From your Table;

Let vFalg=Peek('flag',0,'T1);

Exit Script When $(vFlag)=1;