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

[#1]

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

[#2]

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;

[#3]

Hello Uday R,

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

[#4]

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

[Anonymous]

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

[petter]

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?