topic Storing Data from Variable to QVD in App Development

Storing Data from Variable to QVD

Kaushik2020 — Wed, 21 May 2025 09:42:10 GMT

Dear All,

I have a situation where I am thinking if below scenario is possible or not. Below a sample on how the data is loaded step by step.

1. Load Data model via Binary Load.

2. Created 50 variables via Load editor.

I am looking for an option, it it is possible ? Call a column from the Data Model --> EmployeeName + these 50 variables into a QVD ?

So the Store option will store these Dimension (EmployeeName) and these 50 variables as a measure into a QVD.

Thanks in advance.

Re: Storing Data from Variable to QVD

marcus_sommer — Wed, 21 May 2025 16:13:29 GMT

In general it's possible - but it may depend what the variables contain respectively if they should be evaluated in any way. I assume that not calculated but static variable-values should be stored else any kind of evaluation - and then it's quite likely not trivial anymore.

Re: Storing Data from Variable to QVD

Kaushik2020 — Thu, 22 May 2025 05:01:59 GMT

Thanks a lot for your swift reply. its a set expression -- sample one is here --> Sum( {$<Year={2021}>} Sales )

If we have just a simple measure, Sum(Sales) then we are able to store it from a variable to a QVD.

Re: Storing Data from Variable to QVD

marcus_sommer — Thu, 22 May 2025 05:20:54 GMT

Until the load has finished only table-data exists and not a data-model. Therefore no measurements like a sum(Field) could be directly queried.

But it's possible to run n loads within any loop against the loaded tables which perform the aggrgeation + conditions and fetching there results per peek() which may then loaded within an output-table. It depends on the requirements and the detailed circumstances how suitable such approach may be or if there are other and easier ways to get the needed data and views.