Load Particular day

[sat_tok52]

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

[sunny_talwar]

Try this may be:

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

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

     Table:

     LOAD ...

ENDIF;

[#3]

Hi Sateesh,

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

[sunny_talwar · Accepted solution]

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;

[deepakqlikview_123]

PFA

[#6]

I guess you forgot to attach the attachment.

[Anonymous]

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

     [

     A

     B

     C

]

Regards

Gireesh.