topic Re: Date Qlikview in QlikView

Date Qlikview

Fri, 20 Nov 2020 18:02:30 GMT

Hello good day,

I would like to know how can a database that has a date field, declare a variable of type date to assign to that field and is updated every day to recharge.

Example

Let Date1= Date(Today())

Re: Date Qlikview

swuehl — Mon, 30 Nov 2015 17:20:18 GMT

Not sure what you are trying to achieve.

Let Date1 = Date(Today());

will assign today's date to variable Date1. What do you want to do with this variable with regard to the database date field?

Re: Date Qlikview

eduardo_sommer — Mon, 30 Nov 2015 17:37:14 GMT

Hi Angel,

If you want to include a field in a table, with today's date as it's content, include the line

Set TodayDate=today();

and in the load statement of the table, include the following line

Load ...

...

$(TodayDate) as TodayDateField,

...

Is that what you were looking for?

Regards

Eduardo

Re: Date Qlikview

engishfaque — Tue, 01 Dec 2015 07:16:27 GMT

Dear Angel,

Please use "LET DATE = Date(Today());" in your edit script tab "Main".

Whenever your script will reload, DATE variable will automatically update with Today date.

Kind regards,

Ishfaque Ahmed