topic IF not Working in a load in QlikView

IF not Working in a load

Tue, 05 Jul 2011 12:36:48 GMT

HI,

i define in a load section a IF but i have an error that i don't understand

Load

cas_id,

if(note.devis=1, round(sum(note.temps_realise),1), 0) as fact_hors_devis,

but in the load i have a message that fact_hors_devis is not defined

Thanks

Cyril

IAMDV — Tue, 05 Jul 2011 12:43:16 GMT

Hi Cyril,

Please try with square brackets or "" surronding the field names. If this does not work please can you postthe complete script?

IF([note.devis]=1, Round(Sum ([note.temps_realise]),1), 0) as fact_hors_devis,

Thanks,