Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Supertendi
Contributor II
Contributor II

LOAD INLINE TODAY

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

qvCattura.JPG

how can i get the today date?

 

1 Solution

Accepted Solutions
skamath1
Creator III
Creator III

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

];

View solution in original post

3 Replies
tresesco
MVP
MVP

Try using variable like,

Let vToday=today();

Load * Inline [

Field

vToday

]

skamath1
Creator III
Creator III

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

];

View solution in original post

Supertendi
Contributor II
Contributor II
Author

it works,

thanks a lot