Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Script Flag days between start date & yesterday

I would like to be able to create a flag in the script for all days between the start date of my data (this is based on the yearstart of the minimum date in my import data) and yesterday.  The start date can vary depending on the import data.

Likewise I would like to be able to create an additional flag for days between today and the end date of my data.  Again the end date can vary depending on the import data.

Does anyone have any ideas?

1 Solution

Accepted Solutions
Not applicable

Script Flag days between start date & yesterday

Hi,

is this one date field? Then you can say

load

     ...

     if(datefield < today(), 'historie', 'future') AS flag;

select sql *

from table

Hope you mean this.

Regards vicky

1 Reply
Not applicable

Script Flag days between start date & yesterday

Hi,

is this one date field? Then you can say

load

     ...

     if(datefield < today(), 'historie', 'future') AS flag;

select sql *

from table

Hope you mean this.

Regards vicky