topic Script variable in QlikView

Script variable

mostal75 — Sat, 15 Sep 2018 06:44:38 GMT

Hello,

I have a variable X1 like

=sum({"MyBookmark")Amount)

created manually into my app

I would like to retrieve into my script X1 value to store in QVD.

Do you have any idea because I have errors or definition (no evaluated variable) with

LOAD $(X1) as Amount1 autogenerate 1;

LOAD '$(X1)' as Amount1 autogenerate 1;

Regards

Re: Script variable

swuehl — Sat, 15 Sep 2018 17:59:19 GMT

You can't use set analysis in the script.

You would need the 'traditional' way to get your sum, i.e. using a LOAD from a data source with the field Amount and WHERE clause to filter the records.

Maybe you can create a variable to retrieve the field selections in state MyBookmark after a reload and parse this variable in the next reload to get your aggregated filtered Amount and store to a QVD.

Maybe it's easier to do all this in the UI.

Re: Script variable

mostal75 — Sun, 16 Sep 2018 16:03:21 GMT

Thank you very much Stefan

I've tried with a variable defined like that vINF=sum({"MyBookmark")Amount)

In charts, $(vINF) works fine but not in script (formula retrieve, not variable value), with

LOAD '$(vINF)' as Amount1 autogenerate 1;

LOAD $(vINF) as Amount1 autogenerate 1;

Do you have any idea please ?

Regards