loader image

Table of Contents

Overview

LogiExport® is a brilliant and easy excel export solution to Qlik sense.

  • Save time on Excel labor – the file is exported exactly as you like it.
  • Fast single click exports.
  • Human error-proof – fully automated process.
  • Simple extension implementation – one zip file (no client or server installation).
  • Use your existing file as a template.
  • Distribution ready file – no macros and security issues.
  • Data context included – embed your selections, variables, etc. in the file.

Download for free now: logiexport.logsys.co.il

Watch a demo:

Getting Started

Get LogiExport

Go to logiexport.logsys.co.il and download the free trial.

Install

  1. Open Qlik Management Console.
  2. Select Extensions on the QMC start page or from the Start drop-down menu.
  3. Click Import.
  4. Click Choose File and select .zip file.
  5. Click Open in the File explorer window.
  6. Click Import.
  7. Refresh the Qliksense page, and you will now see the LogiExport under your Custom Objects -> Extensions.

Source: https://help.qlik.com/en-US/sense-developer/September2020/Subsystems/Extensions/Content/Sense_Extensions/CustomComponents/custom-components-installing.htm

Quick Example

Video

Features

Button Settings

Object ID to Export

The table object to be exported.
you can discover the object’s Id in two different ways:

  1. Add “/options/developer” at the end of the current browser address and hit Enter, right click on the object -> developer, the Object ID will be the first value in the pop
  2. Leave Edit mode and right click on the object -> (Share) -> embed -> the object ID is below the preview image.

Button Label

The label of the export button.

Button Style

Set the button Style.

Design by tempale file (Pro version)

Allows the user to upload an xlsx file to be the template for the future exports, this procedure is done once, and the file will be used in all the future exports. Can be any xlsx file.

The Template file is uploaded to your “App Content” library.

Browse

Browse for the template xlsx file. Please clear the file from any actual data. Please see more in the dedicated section: .

Upload new template

Upload the Xlsx file to be used as a template to the future exports, the template file will be associated with the specific LogiExport button, a popup will appear when done.

Download current template

Downloads the current xlsx template associated with this button.

Paste data cell

The excel address within the template file to insert the exported data, the Sheet and Cell (for example DataSheet!A2).

Paste selection cell

The excel address within the template file to insert the selection details.

File settings

File name

The file name of the xlsx file excluding the extension.
example =’Claims Report As Of ‘ & Today().

Sheet formatting

Controls the format and structure of the exported Excel Sheet.

Custom Sheet Name

The name of the sheet in the exported xlsx file.

Report headline

Inserts a headline in an additional line in the top of the Sheet. 

Right to left

Change the Sheet Direction to Right-to-Left.

 

Keep Original Colors (BETA)

Export the table with the font color and the background color as defined in the table Visualization.

Add selection context to file

Inserts the Current Selection details in an additional line(s) in the top of the Sheet.

Selections context cell (optional)

Custom locateing the Selection context data within the sheet, if empty it will be automatically located as described above.

Selections context label (optional)

Inserts a header in an additional line on the top of the selections.
example: =’Selections :’.

Fields excluded from selection context

Exclude Specific Fields from the Selections Export (System Fields etc.). The value is the names of the fields, comma-separated.

Add totals row

Add the table’s totals row on the bottom of the sheet.

Bold totals row

Make total row font Bold.

Table border color

Set the table borders color in hex.
example: =’ff0000′.

Table border style

Set the table borders style.

Column header formatting

 

Bold Headers

Make the table headers bold.

Headers background color

Set the table headers background color in hex.
example: =’ff0000′.

Headers text wrap

Set the table headers wrap text to On.

Headers font size

Set the table headers font size.

Headers horizontal alignment

Set the table headers text horizontal alignment.

Headers vertical alignment

Set the table headers text vertical alignment.

Headers font family

Set the table headers font family.

Headers text color

Set the table headers text color in hex.
example ff0000)

Column formatting

Column Options

Add one column options element for every field you want to custom format, the rest of the fields will keep the regular format.

Column name

The column name to be custom formatted, as it is in the field label in the source table.

Drop column

Remove the column from the exported file.

Hide column

Hide the column in the exported file.

Is hyperlink
Display column data as a link.

Link text column offset

Set the column for the link text.
For example: 2 means: take the hyperlink text from the 2 columns forward from the hyperlink column.

Column horizontal alignment

Column text horizontal alignment

Add conditional formatting

Add one or multiple conditional formatting to the column,

Formula :
The excel Formula of the conditional Formatting,
placeholders:
# – points to the current column
~ points to another column
for example:
#>=0 (this column value bigger than 0)
L~># (L column value bigger than this column value)

Conditional font color: the font color in hex to to be applied when condition is fulfilled.

Conditional back color: the background color in hexto to be applied when condition is fulfilled.

Column Font Color

A custom font color to the column in hex rgb.
example: ff4400.

Column Back Color

A custom background color to the column in hex rgb.
example: ff4400.

Column Font

A custom font to the column text.

Column format

Set a custom Excel format to the column.
example: #,##0.0, dd-mm-yyyy etc.

Column underline
Underline the column text.

Column bold

Bold the column text.

Column width

Set the column width (in points), leave zero for default width.
To hide a column please check the “Hide Column” option.


Freeze Panes

Freeze columns count

Number of columns to keep visible on top while the rest of the sheet scrolls

Freeze rows count

Number of rows to keep visible on top while the rest of the sheet scrolls

Advanced

API

Customize your export using Excel JS API.
example:
='workbook.sheet("Total Individual Claims").range(15, 1, 15, 1).value("$(=GetFieldSelections([Vehicle Make]))");'

See snippets and examples in the dedicated blog post

 

 

Debug Mode

Send diagnostic data to developer.