topic Re: Save a calculation as a data record. in QlikView

Save a calculation as a data record.

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

This is a interesting one. I have production plan that is live with no audit or historical data logging. When i run the qlikview presentation and sum the currently value for the work load its a capture at that point in time.

Is there a way to record stamp this as per that data and save it as a record so that if i wish to review the last few weeks i would have the daily sums?

Remember the data base always changes.

Thanks Brett

Re: Save a calculation as a data record.

micheledenardi — Fri, 26 May 2017 12:18:42 GMT

You have to create daily QVDs and then load it into your presentation.

Re: Save a calculation as a data record.

bnelson111 — Fri, 26 May 2017 14:32:18 GMT

Without sounding silly whats the easiest way over achieving that automatically and dating it.

Re: Save a calculation as a data record.

Nicole-Smith — Fri, 26 May 2017 14:59:53 GMT

You could add a timestamp of current day onto the name of the qvd that you are storing:

LET vToday = date(today(), 'YYYYMMDD');

STORE * FROM Table INTO QVD_Name_$(vToday).qvd (qvd);

This will create a new QVD everyday that your data loads. If you have more than one table in your data model, you will need more than one STORE statement.

Re: Save a calculation as a data record.

bnelson111 — Sat, 03 Jun 2017 09:04:15 GMT

Thanks, could i store the expression result only and save sum below under DD/MM/YYYY which it relates to ?

For example :

num(sum({<PSADATA.processtype={"*prt*"}>} PSADATA.quantity) ,'#,##0')

Re: Save a calculation as a data record.

Anonymous — Sat, 03 Jun 2017 09:34:24 GMT

You must do that in script, set analysis are only allowed in frontend.

If PSADATA.quantity and PSADATA.processtype are within one table,

you could do somethink like that in script:

STORETABLE:

noconcatenate

LOAD

sum(PSADATA.quantity) as SUMPSADATA.quantity

Resident YOURTABLE

WHERE wildmatch(PSADATA.processtype,'*prt*')

group by YOUR.GROUPING.DIMENSION

;

store STORETABLE into STORE.qvd (qvd);

drop table STORETABLE;