Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I don't know if this can be done at all: I would like to store the most important figures calculated in a document into qvd files (just one result per day) so I can build a new management-superstructure loading those qvd files and just displaying them in a gauge or something.
Can I write such a command into the script? If so, what do I have to keep in mind doing that? The first time I tried, I typed like
>> STORE sum(Actual - Goal) into QVD\Res_shipped.qvd; <<
QlikView did recognize the fieldnames (they went reddish), but then it said "FROM wrong" - but I was not building a LOAD statement? I don't think I can reference the formula names, QlikView never seems to recognize those?
Can anyone lend me a hand here?
Thanks a lot!
Best regards,
DataNibbler
The store command can only store fields from tables or entire tables in qvds. So you need to add the results to a table first with a load statement and then store the table.
The store command can only store fields from tables or entire tables in qvds. So you need to add the results to a table first with a load statement and then store the table.
How this can store in Qlikview you need to store actual and goal as different fields and after loading data you need perform calculations in qvw.
Vikas
Hi F,
You need to store a table in the QVD file, not a formula. You need to do something like this:
yourTable:
Load
sum(Actual - Goal) as yourField
Resident anotherTable;
STORE yourTable into YourQVDFile.qvd (qvd);
I hope this helps.
Hi,
yes, this helps. So I will add a LOAD statement and load the result of a formula as a field. Then I actually need two fields to make up my "table" that I can store into a qvd: A date and a calculated value.
That will get me started.
Thanks a lot!
Best regards,
DataNibbler
Please mark the asnwers as correct or helpful.
Hi,
is there a difference between variables defined in the script and variables defined via the variable_overview_window?
I am trying to build a LOAD statement in a RESIDENT LOAD from the main table, but only containing one "field", that is a variable
What I am currently trying is
Erg_Schaeden:
LOAD
(Ziel_Jahr - sum(Schaeden)) / (round(YearEnd(TODAY()) - TODAY())) as Tagesgrenze_Zuk
RESIDENT Schadensfaelle;
I keep getting an error "Invalid expression".
Is there something I cannot do in the script?
Thanks a lot!
Best regards,
DataNibbler