A clear vision, candid communication, strong execution, and a focus on creating value together. 

In his first interview as Qlik CEO, Saugata Saha shares what customers and partners can expect from his leadership and why collaboration across the Qlik ecosystem will be central to the opportunity ahead. 

In the full conversation, Saugata also discusses: 

• What drew him to Qlik  

• His perspective on data and AI  

• The importance of Qlik’s customers and partner ecosystem  

• His priorities for the first 90–100 days  

Watch the full conversation:

As Saugata shares, the future is bright! To help you look ahead in style, we're sending Qlik sunglasses to our Qlik Community members 😎 

Please join us in welcoming Saugata to Qlik and the Qlik Community. Share your reactions and thoughts with Saugata below, and we will send you a pair of Qlik shades (while supplies last). 

Hi all, good evening,

I need to compare the cumulative sales between a year and the year before. This for many years stored in my database.

The sales had already been normalized by the month of each year.

This is the expression I created to generate the information for each year:

Aggr(RangeSum(Above(Sum(QTY), 0, RowNo())), [SALES YEAR, [YEAR/MONTH])

And this is the generated graphic:

What I need is to created a new graphic that shows, for each year, the % growth between that year vs its last year, using the same rule (acumulated sales for each month).

I have already tried many solutions here in the topics, but I couldn't get the right result.

For exemple: Aggr(RangeSum(Above(Sum(QTY) / Sum({<[SALES YEAR] = {"$(=Only([SALES YEAR])-1)"}>}QTY), 0, RowNo())), [SALES YEAR, [YEAR/MONTH])

Thanks in advance for any help.

In Qlik Sense, I have a sheet containing a Filter Pane with a Region field and a Straight Table displaying data based on the selected Region.

The Region filter contains three values:

• Region 1
• Region 2
• Region 3

I need to create an Excel report using Qlik Automation with the following requirements:

1. Only one Excel workbook should be generated.
2. The workbook should contain three separate sheets:
   • Region 1
   • Region 2
   • Region 3
3. Each sheet should contain only the data from the Straight Table corresponding to that particular Region.
4. The automation should dynamically apply each Region as a filter, retrieve the filtered Straight Table data, and write it to the respective Excel sheet.

Question: What Qlik Automation blocks and configuration should be used to achieve this requirement?

per default qlik supports only ports 22 and 2222 for SFTP connections.

i created a connection to a host with port 22 then i tried to edit the port in qmc connection string to 443.

geting the error: The following parameter validation errors were found: sftpPort: Port is invalid.

I see no reason why a SFTP service should not be able to run any ports.

Is there a way how to workaround this?

Hello y'all,

I've got a regular .csv file, with around 30 regular columns. However, a couple of columns are JSON text.

I would like to parse the JSON text and get some extra columns from it.

I've tried to use a tExtractJSONFields, but there are two flaws:

- the component seems to be expecting a full JSON input, not a JSON column among regular string-type columns

- I hardly know anything about Json paths and Json queries 

The JSON column is called 'jugement', one of the JSON property I need from it is called 'complementJugement', so I've used '$.jugement' as the Jsonpath query and 'complementJugement' as the Json query mapped to a new schema column. I got this error message:

Expected to find an object with property ['jugement'] in path $ but found 'java.lang.Integer'. This is not a json object according to the JsonProvider: 'com.jayway.jsonpath.spi.json.JsonSmartJsonProvider'.

Can anyone help me with this issue?

Thanks in advance

Hi friends,

I have been using Qlik web connector for Facebook, Twitter and Youtube data but can't find a connector for Instagram.

Is there a way to extract the data from Instagram in Qlik Sense using any other connector. If yes, Can someone please guide me.

Looking forward for positive replies.

Thanks and Best Regards