Expression meaning

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

What does this expression mean please:

LISTECIP:
LOAD Concat(CODE,'#,#') as ListeCODE
resident PRODUIT

;

let liste_code= chr(39)&replace(peek('ListeCODE',0,'LISTCODE'),'#',chr(39))&chr(39);

Re: Expression meaning

tresB — Tue, 30 Jan 2018 09:53:22 GMT

Load Concat(CODE, '#,#') as ListeCODE

This section of code concatenates all the codes separated by #,# symbols. That is ListeCODE would have values like:

Code1#,#Code2#,#Code3#,#.....

The variable declaration, reads the value from the field ListeCODE to the variable liste_code after replacing # with char(39)character, i.e. - ' (single quote), and an extra char(39) at the beginning and end of the string. Hence the variable would hold a string like:

'Code1','Code2','Code3',....

Hope this helps.

topic Expression meaning in QlikView

Expression meaning

Re: Expression meaning