topic Re: Update a field in QlikView. How can I do it? in QlikView

Update a field in QlikView. How can I do it?

Fri, 03 Apr 2015 02:20:51 GMT

Hi All,

Want to update a field in QlikView. I used below script but seems to be something wrong in syntax and It is show red under line in script editor.

LET vNow=Now();

LOAD_ON_REQUES_CONFIG:

LOAD * INLINE [

RunDateTime, NumberOfMonths, LoadFlag

$(vNow), 12, 0

$(vNow), 18, 0

$(vNow), 24, 0

];

UPDATE LOAD_ON_REQUES_CONFIG SET LoadFlag=1

WHERE NumberOfMonths=12 AND date#(RunDateTimenum, 'YYYY-MM-DD')=date#(Today(), 'YYYY-MM-DD') AND LoadFlag=0;

Could you please help me in correcting it

Message was edited by: Shivendoo Kumar

Re: Update a field in QlikView. How can I do it?

Fri, 03 Apr 2015 02:37:27 GMT

Please try this script:

SET TimestampFormat='YYYY-MM-DD h:mm:ss TT';
LET vNow=Now();

LOAD_ON_REQUES_CONFIG:

LOAD * INLINE [

RunDateTime, NumberOfMonths, LoadFlag

$(vNow), 12, 0

$(vNow), 18, 0

$(vNow), 24, 0

]

//UPDATE LOAD_ON_REQUES_CONFIG SET LoadFlag=1

WHERE NumberOfMonths=12 AND Date(Floor(Timestamp#(RunDateTime,'YYYY-MM-DD h:mm:ss TT')),'YYYY-MM-DD')=Date(Floor(Timestamp#(Today(),'YYYY-MM-DD h:mm:ss TT')), 'YYYY-MM-DD') AND LoadFlag=0;

Re: Update a field in QlikView. How can I do it?

Fri, 03 Apr 2015 02:52:03 GMT

Hello Uday R,

I want to update field LoadFlag later to 1. So I am looking for update.

Re: Update a field in QlikView. How can I do it?

Fri, 03 Apr 2015 03:21:47 GMT

Hey,

Sorry for late reply.

Hope below script would solve problem:

LET vNow=Now();

LOAD_ON_REQUES_CONFIG:

LOAD * INLINE [

RunDateTime, NumberOfMonths, LoadFlag

$(vNow), 12, 0

$(vNow), 18, 0

$(vNow), 24, 0

]

WHERE NumberOfMonths=12 AND Num(Date(Floor(Timestamp#(RunDateTime)),'YYYY-MM-DD'))=num(date(Today(),'YYYY-MM-DD'))
AND LoadFlag=0;

Tab2:
Load * , 1 as NewFlag

Resident LOAD_ON_REQUES_CONFIG;

Output:

RunDateTime	NumberOfMonths	LoadFlag	NewFlag
4/3/2015 8:54:38 AM	12	0	1

Note: If you do not want LoadFlag field, drop it from Table

Re: Update a field in QlikView. How can I do it?

Anonymous — Sat, 04 Apr 2015 08:36:39 GMT

Hi Shivendoo,

you can use this script. i have created a sample app attached for the same

LET vNow=Now();

Temp:

LOAD * INLINE [

RunDateTime, NumberOfMonths, LoadFlag

$(vNow), 12, 0

$(vNow), 18, 0

$(vNow), 24, 0];

NoConcatenate

LOAD_ON_REQUES_CONFIG:

Load RunDateTime, NumberOfMonths,

if (NumberOfMonths=12 AND Num(Date(Floor(Timestamp#(RunDateTime)),'YYYY-MM-DD'))=num(date(Today(),'YYYY-MM-DD'))

AND LoadFlag=0,1,LoadFlag) as LoadFlag

Resident Temp;

Drop table Temp ;

Please mark Correct and Helpful answer

Re: Update a field in QlikView. How can I do it?

petter — Sun, 05 Apr 2015 15:19:19 GMT

Are you asking for how "Dynamic Update" works - that can be used in an application at run-time on request? Opposed to doing an update during Load Script reload?