topic LOAD INLINE TODAY in QlikView

LOAD INLINE TODAY

Supertendi — Sat, 16 Nov 2024 18:18:59 GMT

Hi All,

I have to load some value to different dimension and one of them has to be Today Date.

this is the script

LOAD * INLINE [
Data_Scadenza, Banca_app, Importo
2020-07-24 00:00:00.000, 'USD - CREDEM C/C' , 500
$(Today()), 'USD - CREDEM C/C' , 350

];

and this is the result

how can i get the today date?

tresB — Fri, 24 Jul 2020 15:15:00 GMT

Try using variable like,

Let vToday=today();

Load * Inline [

Field

vToday

]

skamath1 — Fri, 24 Jul 2020 15:18:02 GMT

Try the following code

LET vToday = Today() ;

data:
LOAD * INLINE [
Data_Scadenza, Banca_app, Importo
2020-07-24 00:00:00.000, 'USD - CREDEM C/C' , 500
$(vToday), 'USD - CREDEM C/C' , 350

];

Supertendi — Fri, 24 Jul 2020 15:21:55 GMT

it works,

thanks a lot