topic Re: Trigger help in QlikView

Trigger help

ajaykumar1 — Mon, 26 Oct 2015 11:36:01 GMT

Hi Everyone,

I have the below requirement and done the below way.

I need to run my Application based on the database value.So I have created one Dummy Extractor/Generator and scheduled through QMC every 15 mins and the script as below.

CHECK:

LOAD Status,

Import_Date

FROM

//Idleally its DB table name

(ooxml, embedded labels, table is Sheet1);

IF Peek('Status') ='Y' THEN

STORE CHECK INTO E:\qvsdocs\qvd\Flag_Test.QVD;

END IF;

In my applition i have mentioned the below condition;

if(QvdCreateTime('E:\qvsdocs\qvd\EDW_Flag_Test.QVD')>= today()) then

My entire script.

endif;

Problem : Once my qvd E:\qvsdocs\qvd\Flag_Test.QVD is generated and application is running thats fine.But my "Dummy Extractor is running every 15 mins.So my application is also started running because it scheduled based on the Dummy extractor.

I want to stop running of My dummy Extractor Once the E:\qvsdocs\qvd\Flag_Test.QVD is generated.

More thanks,

Ajay

Re: Trigger help

ajaykumar1 — Mon, 26 Oct 2015 13:20:57 GMT

Hi,

Anyhelp from anyone or is there any alternate solution to achieve the above task?

More Thanks,

Ajay

Re: Trigger help

rubenmarin — Mon, 26 Oct 2015 13:49:49 GMT

Hi ajay, one idea that maybe works:

Modify dummy extractor starting to check if a previous flaq_test is created:

if(QvdCreateTime('E:\qvsdocs\qvd\EDW_Flag_Test.QVD')>= today()) then

LOAD * Resident ProvokeError: // This row will return an error if EDW_Flag_Test.QVD was created today()

else

your script...

...

Then you can configure the reload of the application when Dummy Extractor reload task is ended with sucess.

Re: Trigger help

ajaykumar1 — Mon, 26 Oct 2015 14:04:08 GMT

Thanks Ruben,

But you mentioned script above script i used in the application.

I didnt get what i need to change at dummy extractor level.

THanks,

Ajay

Re: Trigger help

rubenmarin — Mon, 26 Oct 2015 14:11:09 GMT

App will reload only one time, when extractor ends as success and the qvd was created today.

1.Until qvd is generated extractor will end as success, thee app tries to reload but checking the date of the EDW_Flag_Test.QVD file goes to the else and doesn't reloads anything

2.First time the Status='Y' the extractor will create the file, ends as success and the app reload is executed and fully reloaded

3.Next execution after the first full reload: The extractor check if he created the qvd this day, the file is created so it finish with an error. As it's not a success the reload of the application won't be executed.

Re: Trigger help

ajaykumar1 — Mon, 26 Oct 2015 14:19:34 GMT

Thanks ruben,

I am still getting problem at 1st step only.2 and 3 i understood.

1.Until qvd is generated extractor will end as success, thee app tries to reload but checking the date of the EDW_Flag_Test.QVD file goes to the else and doesn't reloads anything------------------Not understood.

Could you please add script if possible.

More Thanks,

Ajay

Re: Trigger help

Qrishna — Mon, 26 Oct 2015 14:25:22 GMT

Check the 'Edit Task' Properties and reconfigure them.

I guess you made a depedency for the Application on the QVD generator run status.

Re: Trigger help

rubenmarin — Mon, 26 Oct 2015 14:26:26 GMT

That step is the way it's working now, isn't it?:

The extractor reloads each 15 minutes, when it ends the app tries to reload, does the "if(QvdCreateTime('E:\qvsdocs\qvd\EDW_Flag_Test.QVD')>= today()) then", as it's still not created today goes to the else of this 'if', so avoids all the script.

the script for extractor:

if(QvdCreateTime('E:\qvsdocs\qvd\EDW_Flag_Test.QVD')>= today()) then

LOAD * Resident ProvokeError: // This row will return an error if EDW_Flag_Test.QVD was created today()

else

CHECK:

LOAD Status,

Import_Date

FROM

//Idleally its DB table name

(ooxml, embedded labels, table is Sheet1);

IF Peek('Status') ='Y' THEN

STORE CHECK INTO E:\qvsdocs\qvd\Flag_Test.QVD;

END IF;

End if

Re: Trigger help

ajaykumar1 — Mon, 26 Oct 2015 16:03:05 GMT

Once Thanks again Ruben.It looks it should work perfectly.

I will close thread asap when am applying the logic.

Thanks,

Ajay

Re: Trigger help

ajaykumar1 — Wed, 28 Oct 2015 18:29:10 GMT

Thanks its working.

Ajay