reloading front end values back into script without using macro/variable

Wed, 09 Apr 2014 17:38:30 GMT

Hi All,

I have a number of metrics which i calculate at the front end. many require set analysis expressions, and /or certain selections.

What i would like to do is load a table in the script which would record these values, and export them to a qvd which would be timestamped. Then this would be loaded back into the dashboard , along with the timestamp so we could view historic trending. basically, we would have a row for each time the data was refreshed, i.e. each new timestamp.

Previous attempts have included a macro which exports the underlying table and it's associated values. Due to the server our files reside on this is not an option.

Futhermore i have modelled a table using many joins etc to get some of the figures but I'm just wondering if there is a better way.

Does anyone know of a way in which we can reference front end expressions (which would be variables) which would be a specific value and load this into a table. Previous attampts at this have simply loaded the expression contained in the variable (i.e. the expression syntax) but no actual numeric values which is the requirement.

Any thoughts/suggestions would be much appreciated.

topic reloading front end values back into script without using macro/variable in QlikView

reloading front end values back into script without using macro/variable