topic Re: today()-3 in QlikView

today()-3

n1ef5ng1 — Fri, 18 Oct 2013 03:02:10 GMT

Hi all,

Example that today is Oct 18th, however in our database, it takes three days to completely capture all the data as some late entry of the data still have not capture, thus we gives a three days buffer to get the full set of data.

As per this scenario, the complete set of data is 15th as it is today()-3

However there are still some data exist on 16th and 17th even though it is not a complete set. Is there any code in QV that tells them to capture data till 15th and ignore 16,17 data.

Thanks

Re: today()-3

v_iyyappan — Fri, 18 Oct 2013 04:02:13 GMT

Hi,

Try like this

Load

From tablename

Where datefield <= (Today() - 3);

please check the dateformat in datefield.

regards,

Re: today()-3

jagan — Fri, 18 Oct 2013 04:11:25 GMT

Hi,

Try filtering the data from the table by using the following where condition

Data:

Load

From DataSource

Where DateDimension <= Date(Today() - 3);

If filtering is not working then check the date formats of DateDimension and Today() are same.

Regards,

Jagan.

Re: today()-3

n1ef5ng1 — Fri, 18 Oct 2013 04:14:05 GMT

Possible to not touch the script? Possible to make these on dimension or expression?

Re: today()-3

jagan — Fri, 18 Oct 2013 04:32:59 GMT

Hi,

Then try like this in all your expresions

=Sum({<DateFieldName ={'<=$(=Date(Today()-3))'}>} MeasureName)

Hope this helps you.

Regards,

Jagan.

Re: today()-3

jagan — Fri, 18 Oct 2013 04:34:21 GMT

Hi,

You can do this in a better way like this also

Create a variable

vDateRange = Date(Today() -3)

=Sum({<DateFieldName ={'<=$(=vDateRange)'}>} MeasureName)

Hope this helps you.

Regards,

Jagan.

Re: today()-3

senpradip007 — Fri, 18 Oct 2013 04:47:53 GMT

Hi,

Try this

Data:

Load

from <Table Name>

where <DataField> <= Date(Today() - 3);

Re: today()-3

saumyashah90 — Fri, 18 Oct 2013 04:51:44 GMT

hey you can try this in expression

=Date(Today()-3,'DD-MM-YYYY')

Re: today()-3

er_mohit — Fri, 18 Oct 2013 05:13:36 GMT

Make a variable vMaxDate=Date(Today() -3)

and Go to document properties --> In document event trigger-->on open -->add action

click on add->select in field--> Write fieldname like Date

and in string write

=vMaxDate

then sav it ok

close the application then reopen it your Data will be shown less than today date - 3

hope it helps

Re: today()-3

tresB — Fri, 18 Oct 2013 05:30:19 GMT

May be like attached sample?