Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

homersimpson
Contributor II

Load Script - change field value

Hi,

how can i change the value in a loading script like this?

2017-01-17_20h02_35.jpg

I try it by this way, but it shows that´s wrong:

tbl_sumApr:

LOAD

    sDate as newDate(['01.04.2017']),

    Product as newProduct,

    Sales as newSales

Resident tbl_jan;

regards,

sam

3 Replies
MVP
MVP

Re: Load Script - change field value

Looks right, what is the issue?

MVP
MVP

Re: Load Script - change field value

Try

Date(Makedate(2017,4,1),'DD.MM.YYYY') as  newDate,

homersimpson
Contributor II

Re: Load Script - change field value

Thanks!

This works fine:

MakeDate(2017,4,1) as newDate

2017-01-17_21h30_31.jpg