If load

[#1]

If nooffailures=0

Load

calendarkey...

where  calendarkey=today()>today()-120;

else

Load

calendarkey...

where  calendarkey=today()>today()-90;

Can any one suggest how to do this requirement.

[jcramirez472]

Can you explain the requirement further? It looks like you want to load a different number of days based on a variable.

[Anonymous]

Something like this maybe.

if nooffailures=0 then

     let vDateCount=today()-120;

else

     let vDateCount=today()-90;

ENDIF;

Load

     calendarkey

From Yourfile

where calendarkey<today()+1 and calendarkey>$(vDateCount);

Update:  Had to edit for the variable.

[Anonymous]

Did you get your answer?

[#5]

Thanks really very good help.

[Anonymous]

Then please close thread by marking a response as the answer.

Qlik Community Tip: Marking Replies as Correct or Helpful