This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
With Qlik Sense, if i have no data model in an app, but has visualisations in it; is it possible to:
* use the API to push a table in the app?
* delete records from the table in the app?
I'm not looking for a hypercube, but really looking for a solution to push a datamodel into the app.
Thanks in advanved
There is no current API to push data into the model.
You can insert script and initiate reload via API.
View solution in original post
Try this out:
1- In the main tab (script editor) put this at the top of code (before variables):
2 - Create a folder connection where you want to save app's qvd files;
3 - Run this code:
FOR i = 0 TO NoOfTables() - 1
LET vTableName = trim(TableName(i));
STORE $(vTableName) INTO [lib://FOLDERCONNECTION/$(vTableName).qvd] (qvd);
drop table $(vTableName);
Then, your data model is there!!
Thanks for your reply.
But i don't want to use any database source, QVD files, QVF or excel files.
I want to use an API call (which contains json with data) and put this into an empty app to create a table.
Well, sorry my mistake...
I'll try to learn something useful about that.
That's really too bad RW ..
Really to bad you also can use partial reload .. but only add .. not update (removing an deleted order for example.)
Not sure if this is what you are after, but there is a library called Halyard js:
Haven't tried it, and I don't know if it solves your problem, but check it out!
Hope this helps
Thanks for this Erik, will sure look into this; but from what i read; This js library can add records, but not update records (or delete and add).
Potentially you could use a partial reload with an inner join to delete rows. Haven't tried it myself.