topic Re: document trigger lost, is a bug ? in QlikView

document trigger lost, is a bug ?

Mon, 21 Jul 2014 10:52:56 GMT

hi,

sometimes my document lose the action on field !! how is possible ?

is a bug ?

i have the last version 11.20 SR7

Re: document trigger lost, is a bug ?

marcus_malinow — Mon, 21 Jul 2014 10:55:32 GMT

If you ever open your document without data, then save it, any field triggers will be lost.

Re: document trigger lost, is a bug ?

alexandros17 — Mon, 21 Jul 2014 10:56:15 GMT

Non mi è mai successo!

Ho la 11 20 SR5

Re: document trigger lost, is a bug ?

sudeepkm — Mon, 21 Jul 2014 10:58:34 GMT

the field trigger action remains as it is as long as you have the field available in your document or the value of that field in the document. any loss in the Field will also result lose in the Field event trigger.

Re: document trigger lost, is a bug ?

Mon, 21 Jul 2014 12:33:06 GMT

but is terrible for me.. if my script don't return any result i lose the trigger !!

how i can do ?

there is a solution ?

Re: document trigger lost, is a bug ?

sudeepkm — Mon, 21 Jul 2014 13:05:07 GMT

I do not think you will face this issue once you upload your document to Server.

I've a QVW which is in Server under source documents and has Field event trigger in it.

Sometimes the field not found error comes and the reload fails but the document goes back to previous state instead of the loading the data without the field. That issue I've only seen in the Desktop.

Re: document trigger lost, is a bug ?

Mon, 21 Jul 2014 13:14:27 GMT

my problem is in this part of script

[code]

let noRows = NoOfRows('TempCalendar')-1;

for index=0 to $(noRows)

let a = peek('TEMP_DTSHOW',$(index),'TempCalendar');

let z = Mid(peek('TEMP_DTSHOW',$(index),'TempCalendar'), 7, 2) & '/' & Mid(peek('TEMP_DTSHOW',$(index),'TempCalendar'), 5, 2) & '/' & Mid(peek('TEMP_DTSHOW',$(index),'TempCalendar'), 1, 4);

CALL CountReferenze;

TableShow:

LOAD * INLINE [

DTSHOW, DTSHOW_FORMATTED, COUNT_ORD, COUNT_ARR, COUNT_CONTR, COUNT_CARIC, COUNT_DDT

$(a), $(z), $(b), $(c), $(d), $(e), $(f)

];

[/code]

if i have noRows = 0, my TableShow don't exist and lose trigger on field DTSHOW FORMATTED

Re: document trigger lost, is a bug ?

alexandros17 — Mon, 21 Jul 2014 13:30:23 GMT

Una soluzione potrebbe essere quella di concatenare la tua tabella con un load * inline dei campi di cui hai bisogno con i valori a zero, in modo da avere sempre la colonna presente

Re: document trigger lost, is a bug ?

Mon, 21 Jul 2014 13:31:54 GMT

vero, bella idea provo subito !

EDIT : confermo così risolve il problema

Ok problem solved, Thank for all !!