topic Re: Metric in a script variable in QlikView

Metric in a script variable

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

When I place the following function in a text object it works:

=num(Sum({<PaiTipoRegisto={'Proveitos'},FactDate = {"$(=Max({<Real_Forecast={"R"}>}FactDate))"} >} Valor) / 1000,'0')&' K'

If you put it in the script with this format :

let vVar=

'num(Sum({<PaiTipoRegisto={'

&chr(39)&'Proveitos'&chr(39)

&'},FactDate = {"$(=Max({<Real_Forecast={"R"}>}FactDate))"} >} Valor) / 1000,'

&chr(39)&'0'&chr(39)

&')&'&chr(39)&' K'&chr(39);

and in text objet:

=$(vVar) or

=$(=vVar)

i got 0 (zero)

what is wrong ?

best regards

Ricardo

Re: Metric in a script variable

vinieme12 — Fri, 21 Apr 2017 11:24:58 GMT

Try

let vVar='num(Sum({<PaiTipoRegisto={' & chr(39)& 'Proveitos' & chr(39) & '},FactDate = {"$(=Max({<Real_Forecast={"R"}>}FactDate))"} >} Valor) / 1000,0)' & chr(39)&'K';

let vVar = 'num(Sum({<PaiTipoRegisto={' & chr(39)& 'Proveitos' & chr(39) & '},FactDate = {"$(=Max({<Real_Forecast={"R"}>}FactDate))"} >} Valor) / 1000,' & chr(39)& '0' & chr(39) &') K';

Re: Metric in a script variable

Aurelien_Martinez — Fri, 21 Apr 2017 11:58:54 GMT

Hi,

SET vVar = =num(Sum({<PaiTipoRegisto={'Proveitos'},FactDate = {"%(=Max({<Real_Forecast={"R"}>}FactDate))"} >} Valor) / 1000,'0')&' K';

LET vVar = replace('$(vVar)', '%', '$');

Re: Metric in a script variable

Anonymous — Fri, 21 Apr 2017 13:12:44 GMT

Almost

LET not set.

LET vVar = =num(Sum({<PaiTipoRegisto={'Proveitos'},FactDate = {"%(=Max({<Real_Forecast={"R"}>}FactDate))"} >} Valor) / 1000,'0')&' K';