topic Re: Creating Qlikview scripts to trigger QVWs in QlikView

Creating Qlikview scripts to trigger QVWs

sabreyals — Tue, 14 Oct 2014 17:40:35 GMT

Hi,

I am trying to create a qlikview script that can run other scripts if and when a certain condition is satisfied.

The idea was to compare the maximum date from database for a table and compare it with the max date in the QVD.

If the difference between the dates is > 0 then i would run the execute command to refresh the QVD.

After i pick up the max dates this is what i am doing.

Let vDateInterval = AS_OF_DT - date(AS_OF_DT_QVD,'MM/DD/YYYY');

if( '$(vDateInterval)' > 0) then

execute "***.bat";

else

exit script;

end if;

However when i debug the script i dont see any value in the vDateInterval variable and as a result my if-then-else doesnt seem to be working properly.

CAn any i done wrong here?

Re: Creating Qlikview scripts to trigger QVWs

maxgro — Tue, 14 Oct 2014 18:31:34 GMT

I suppose it depends on AS_OF_DT and AS_OF_DT_QVD

Could you add some trace before Let statement and post the trace or the log?

Re: Creating Qlikview scripts to trigger QVWs

Anonymous — Tue, 14 Oct 2014 19:00:08 GMT

Hi,

I think you are missing peek the values from the actual fields?

try:

Let vDateInterval = peek('AS_OF_DT', 0, 'FromTable') - date(peek('AS_OF_DT_QVD',0, 'From table') ,'MM/DD/YYYY');

This should work if you have only one value in these fields (it gets the first one).

Best Regards

Stefan

Re: Creating Qlikview scripts to trigger QVWs

sabreyals — Tue, 14 Oct 2014 19:39:21 GMT

Hi Massimo,

I used the trace statement like this

trace $(vDateInterval)

and here's what i got

10/14/2014 3:34:50 PM: 0036 Let vDateInterval = peek(AS_OF_DT,0,'A') - date(peek(AS_OF_DT_QVD,0,'B'),'MM/DD/YYYY')
10/14/2014 3:34:50 PM: 0038 trace
10/14/2014 3:34:50 PM: 0038

10/14/2014 3:34:50 PM: Execution finished.

The variable doesnt seem to be holding any value.

If i create a list box in the document i am able to see the 2 date fields and their values. Any ideas?

Re: Creating Qlikview scripts to trigger QVWs

sabreyals — Tue, 14 Oct 2014 19:40:00 GMT

Hi Stefan,

thanks for your reply. I am using the peek function now but still my variable sems to be empty.

Re: Creating Qlikview scripts to trigger QVWs

Anonymous — Tue, 14 Oct 2014 19:57:29 GMT

Hi,

could please define a variable for each date field like:

let vDateInterval1 = peek('AS_OF_DT',0,'A');

let vDateInterval2 = peek('AS_OF_DT_QVD',0,'B');

and post the content of the variables after reloading your document. It's also possible the subtraction somehow doesn't work.

Best regards

Stefan

Re: Creating Qlikview scripts to trigger QVWs

maxgro — Tue, 14 Oct 2014 19:57:55 GMT

I think you have some problems in AS_OF_DT and AS_OF_DT_QVD

Are these variables or fields? If variable trace it, maybe they are empty

If they are variables, to get the max date from a qvd you should use something like (same suggestion as Stefan)

final:

load max(Orderdate) as Orderdate

from final.qvd (qvd);

vMaxOrderdate = peek('Orderdate');

trace $(vMaxOrderdate);

Post your script, if possible

Re: Creating Qlikview scripts to trigger QVWs

sabreyals — Wed, 15 Oct 2014 18:45:28 GMT

I missed out the single quotes for the field name, that is why my variables were holding a null value. Issue resolved now.

Other than Peek i came across another function called FieldValue which can be used in a similar way.

Thanks,