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

Hello Team,

Can we use Amazon S3 as the source repository, along with AWS Lake Formation and Athena for schema and table creation, and integrate this setup with Qlik Sense to enable writeback and reload functionality?

The objective is to ensure that once users enter and save their data, a reload of the application reflects the latest updates across the dashboard, including all KPIs, charts, bar graphs, and other visualizations.

Could you please clarify whether this approach is feasible and if there are any limitations or considerations that we should be aware of? This is currently a major blocker for me, and your guidance would be greatly appreciated.
Also Please help me with the level of Access like do I need any Automation from Qlik Sense that will write the Data back to S3.

Thanks
Sarvesh

HI, In Qlik Automation I’m calling a PostgreSQL procedure using the Postgre>Do Query block:

I simply put into 'Query *' field:
call schema.procedure_name();

The block usually keeps running for a 2 hours 5 minutes or eventually times out, even though in PostgreSQL the procedure is triggered immediately and finishes in less than a millisecond (based on my logs).

Do you have any experience or recommended block/workaround for this?

Thanks!