topic Re: Load Particular day in QlikView

Load Particular day

sat_tok52 — Thu, 10 Sep 2015 09:27:23 GMT

Hi Gurus,

I have a Sales table ,my requirement is i need to write a condition on top this table like to load this table only the weekday = friday ,If it is not Friday the table should not run. How will i write condition.Please help me.

-Sateesh

Re: Load Particular day

sunny_talwar — Thu, 10 Sep 2015 09:29:56 GMT

Try this may be:

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

IF WeekDay(Today()) = 'Fri' then

Table:

LOAD ...

ENDIF;

Re: Load Particular day

Thu, 10 Sep 2015 09:32:14 GMT

Hi Sateesh,

Can you please provide some sample qvw with the table to make it clear where you want to write the condition.

Re: Load Particular day

sunny_talwar — Thu, 10 Sep 2015 09:34:51 GMT

Try something like this for a sample:

IF WeekDay(Today()) = 'Thu' then

Table:

LOAD Today() as Date

AutoGenerate 1;

ELSE

Table:

LOAD AddYears(Today(), -1) as Date

AutoGenerate 1;

ENDIF;

Re: Load Particular day

deepakqlikview_123 — Thu, 10 Sep 2015 09:38:06 GMT

PFA

Re: Load Particular day

Thu, 10 Sep 2015 09:42:03 GMT

I guess you forgot to attach the attachment.

Re: Load Particular day

Anonymous — Thu, 10 Sep 2015 09:50:00 GMT

hi sateesh,

Open new qlikview document copy past below code , insted of fri day i mentioned thus day,because to show the table

if u want to run the table only friday than u can mention 'fri'. So now with below code it will only open on thurs day.

Code:

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

IF WeekDay(Today()) = 'Thu' then

ENDIF;

Table:

LOAD *

Inline

[

]

Regards

Gireesh.