LLodi Writer Extension

Last updated 3 months ago

Installation

See Getting Started: Installation

Available for QlikView and Qlik Sense

You can use LLodi widgets in all your Qlik projects, choose your favourite platform and use our tools seamlessly.

Natively embedded in Qlik

LLodi widgets works directly from Qlik, as custom extension or connector.

Security

LLodi is cloud-based and inherits the security of your Qlik Analytics Platform. No need to redo or replicate your security model. We do not store customer data.

Getting started

Once you have installed the extension you are ready to use it but to get the most of it and don’t become frustrated let's check a few concepts that can be useful to you.

  • Forms: You create them in your Forms Manager. In the form, you will define how to “paint” the extension in your dashboard (number and type of fields) and what do you want to do with the data provided by the user (how to handle it and where send the payload).

  • GUID: 'Globally Unique Identifier', this number helps you to tell the extension which form has to paint.

  • LLodi Fields: With this special fields you can define where the field will obtain the data from. Use Qlik formulas to get the right data in your extension and combine the data from Qlik with the logic from LLodi.

These are the steps you need to follow to begin to use

  1. Drag and drop the extension into the dashboard.

  2. Introduce the GUID of the LLodi Form you are going to use.

  3. That’s all!

You can add more logic using the LLodi Fields, customize your extension and many more features.

LLodi extension in your Qlik dashboard

Place LLodi Writer Extension in your dashboard

Once you have installed our extension, you will find it in “Custom Objects”. Drag and drop the extension where you want to locate it and fit the size.

In the edition menu there are different tabs that allow you to customize and get the most of LLodi Extension. Let's check them:

Edition menu: Data

GUID

GUID is the acronym of 'Globally Unique Identifier', this number helps you to tell the extension which form has to paint. You can use Qlik Formulas to define the value of this field, this means you can, for example, create an in-line table to have different forms in the same extension and switch between them with a selector.

LLodi Fields

With this special fields you can define where the field will obtain the data from. Use Qlik formulas to get the right data in your extension and combine the data from Qlik with the logic from LLodi.

You can choose in the platform which fields will be used. LLodi Fields can be used too in Dynamic Fields.

Using LLodi Fields to send a mail from Sendgrid

Edition menu: Options

Reload App

In this section you can choose the way the app should be reloaded. You can define full and partial reloads, and even set a delay to wait for the data source to be updated.

Clear Form

If you want, you can clear the form and even the selections when the request is sended. Depending on the response you can change the behaviour or the extension.

Response

In this section you can add custom responses for different HTTP responses codes.

LLodi Agent

LLodi Agent works in the Qlik Sense server between the LLodi call and an external request. It provides additional functionability to your LLodi Platorm:

Know more about LLodi Agent

Edition menu: Send Condition

A condition can be set to allow or forbid the send of the request. To allow the action, the formula must be True (e.g. 1=1).

This feature can be used to force the user to make some selections or to add new layers of security using OSUser from Qlik.

A message can be added to help the user to met the requirements.

Edition menu: Additional Modules

With “Send Condition” you can set some conditions to allow the send of the request, this feature set the conditions show the LLodi Writer Extension, otherwise it will be unavailable.

Edition menu: Style

You can fully customize the appearance of your extension. There are a lot of options to choose between from Font colors to button border radius.

It is also possible to add HTML styles directly.

Edition menu: Look

It is possible to add or hide title, subtitle and foot notes.

Useful formulas

Make a Concatenated list

LLodi Widgets use comma separated lists to build the selectors and to send several values in one shot.

Qlik Sense & QlikView script
concat(field,separator,sortby)
eg:
concat(region,,,regionid)

Make lists of pairs

In most cases you will want to make pairs name-id so LLodi can display the name while uses the id to make the operations under the covers. In those cases you just need to go one step further:

Qlik Sense & QlikView script
concat(fieldname&’|’&fieldid,separator,sortby)
Example:
concat(region&’|’&regionid,’,’,regionid)

Make lists with additional info attached

Once you’ve got started you may think of new LLodi Form that you want to request. For example, you may want to send additional info beside the name and id, such as the total sales amount of one particular client.

Qlik Sense & QlikView script
concat(distinct aggr(only(name)&’|’&id’|’&sum(value),aggregatedby),separator,sortby)
eg:
concat(distinct aggr(only(region)&’|’&regionid’|’&sum(amount),regionid),’,’,region)