Configuration
Time to complete: 3 minutes
When setting up the Komment object ensure that you do not have the data load editor open in a separate browser tab.
Setup screen
Mode: Default mode is Table. Select Form or Popup if desired.Fact Table Name: Select the table from your data model on which you want to relate your write-back to.Date Format: Select the date format you wish to have your date selector values shown in.Writeback Variable Name: Ensure to name unique if you have multiple Komment objects in your app.Writeback Table Name: The name of the QVDs that are stored. Ensure to name unique if you have multiple Komment objects in your app or different apps are storing QVDs to the same location.If you wish to store your QVDs in a subfolder to a given data connection you can change this in the load script later. This is recommended if you have multiple apps which uses Komment.
Define Transports
Connection Type: Select between QIX Engine or KaptainQVD Data Connection: Select the data connection where you want to store your QVDsQVD Storage: This defines whether your data is stored into one QVD or separate QVDs.If you have selected Kaptain as your Data Connection you must be on the Standard plan or higher and have the Kaptain service installed. To configure your Kaptain setup go to this section.
In this section you simply define which fields you want to make it possible to edit and how they should be editable. You can see a full description of each widget type in the Widget section under Features.
Add new widget
Define widgets
Widget Type: Select your Widget type.Mode: Choose between Field or ExpressionQlik Field Name: Select the relevant field name from the defined Fact Table.Komment Key Field: If your selected field is the association between your data model and write-back data then check this field.Widget Label: Define the label for the widget. If nothing is entered the Field Name will be displayed.Continue this for all the widgets you want to add.
We recommend to place the widget holding the Komment Key Field as the first widget
Go back to Setup => Press
Preview Load Script
Preview Load Script
You will now be presented with the auto-generated Komment load script as shown below.
Initialize Data Model
Now press
Initialize Data Model. Komment will now automatically inject the script in your Data Load Editor and do a reload of the application.That's it! You have now successfully configured your write-back solution.
Qlik Engine has a known issue that can occur when initializing the data model. This error warning can safely be ignored as the data model will be initialized correct.
If you want to externalize the Komment script section and use variable based path, you must ensure that the variable is not cleared out after must_include/include function:
//Set script path
LET vScriptPath = ‘lib://myScriptFolder’;
//Include komment logic in qvs file
$(Must_Include=[$(vScriptPath)/Writebacks/Komment.qvs]);
//Clean variables
LET vScriptPath = ‘’;
In above case, Qlik will run into an error when reloading. That’s because Qlik will firstly execute the ‘Clean variables’ part rather than ‘Include’ function. So the suggestion is to either move the clean logic into a qvs with include or remove it if not necessary.
Last modified 1yr ago