Hi All,

I've been trying to upgrade Nprinting Feb 2024 SR1 to SR4,  but in most of the after making all the recommended steps, I execute the installer and instead of say "Upgrade" just says "Install".

If I do the install, it creates a new instance of Nprinting along the current install, If I delete the previous version (SR1) and keep SR4, when I restore the repository and start the services, It requires me the licencing again, which I dont have (yet) and I thought it should be automatically.

Please if anyone had the same issue or know what could be I'd really appreciate your help.

Thanks

Hi Experts,

I have dataset looks like below table:

There is another table having columns Region > Zone > Country.

The problem I am facing is that in pivot table I have hierarchy Region > Zone > Country > Shopkeeper. With this hierarchy, my below two codes were working fine

Code1:

Pick(Match(GetObjectDimension(Dimensionality()-1), 'Region', 'Zone', 'Country', 'Shopkeeper'),

Sum(global shop distribution)/sum(Total <region> global shop distribution),

Sum(global shop distribution)/sum(Total <zone> global shop distribution),

Sum(global shop distribution)/sum(Total <country> global shop distribution),

Sum(global shop distribution)/sum(Total <country> global shop distribution),)

code2:

Pick(Match(GetObjectDimension(Dimensionality()-1), 'Region', 'Zone', 'Country', 'Shopkeeper'),

Sum(AGGR(Sum(global shop distribution)/sum(Total <Region> global shop distribution), Region, Zone, Country, Shopkeeper)),

Sum(AGGR(Sum(global shop distribution)/sum(Total <Zone> global shop distribution), Region, Zone, Country, Shopkeeper)),

Sum(AGGR(Sum(global shop distribution)/sum(Total <Country> global shop distribution), Region, Zone, Country, Shopkeeper)),

Sum(AGGR(Sum(global shop distribution)/sum(Total <Country> global shop distribution), Region, Zone, Country, Shopkeeper))

)

As I change the hierarchy to shopkeeper > region > zone > country first code is running properly but second code is showing different answers.

Code1:

Pick(Match(GetObjectDimension(Dimensionality()-1), 'Shopkeeper', 'Region', 'Zone', 'Country'),

Sum(global shop distribution)/sum(Total < Shopkeeper> global shop distribution),

Sum(global shop distribution)/sum(Total <Region> global shop distribution),

Sum(global shop distribution)/sum(Total <Zone> global shop distribution),

Sum(global shop distribution)/sum(Total <Zone> global shop distribution))

code2:

Pick(Match(GetObjectDimension(Dimensionality()-1), 'Shopkeeper', 'Region', 'Zone', 'Country'),

Sum(AGGR(Sum(global shop distribution)/sum(Total <Shopkeeper> global shop distribution), Region, Zone, Country, Shopkeeper)),

Sum(AGGR(Sum(global shop distribution)/sum(Total <Region> global shop distribution), Region, Zone, Country, Shopkeeper)),

Sum(AGGR(Sum(global shop distribution)/sum(Total <Zone> global shop distribution), Region, Zone, Country, Shopkeeper)),

Sum(AGGR(Sum(global shop distribution)/sum(Total <Country> global shop distribution), Region, Zone, Country, Shopkeeper))

)

I need this because I want to get sum of these calculations at above level plus multiplying these with master item of another calculation. I want to fix this AGGR calculating then my problem will get resolve.

If any suggestions of different approaches will be highly appreciated.

Thanks for your attention.

We're challenging our Qlik Community: put agentic AI to work. 

We saw lots of great posts in our recent Make Your Data Work for AI forum. We’re building on that momentum with a new board focused on the next step: driving real impact with agentic AI.

This is the place to get started with agentic capabilities, try them out, and share your experience with the rest of the Community.

Here's the challenge:

1. Get started. Toggle on Qlik Answers, activate Qlik’s MCP Server, or get started with whichever capability fits your work, and see how easy it really is.
2. Build your first workflow. Identify a use case and put the capabilities to work on a real problem or task.
3. Share your experience. Tell the Community what you learned, what worked, and what surprised you.

Ask questions, share screenshots, get ideas, and help your Qlik Community peers on their journeys.

You'll earn NEW Community badges along the way: Agentic AI Adopter when you share your first workflow or use case, and Agentic AI Expert when you share your learnings and results.

Plus, we’ll be awarding some fun surprises and new Qlik swag along the way!  

Hello Qlik Support Team,

I have a question regarding Qlik Talend Data Integration Data Mart / transformation pipelines.

We have a requirement to execute custom SQL statements before and/or after a Transformation / Data Mart task. One of the use cases is index management — for example, creating an index on a target table after the Transformation / Data Mart step has created the table or populated the table.

For example, we would like to achieve a workflow similar to:

1. Execute a pre-action SQL statement (if required)

2. Execute the Qlik Transformation task

3. Execute a post-action SQL statement, such as:

   • Create or rebuild indexes

   • Update statistics

   • Execute a stored procedure

   • Perform other target-database maintenance

Is there a supported way in Qlik Talend Data Integration / Qlik Cloud Data Integration to implement such pre- and post-processing SQL hooks for a Data Mart or transformation task?

If there is no direct pre/post hook functionality, what is the recommended Qlik-supported approach for implementing this type of orchestration?

For comparison, I understand that Qlik Compose provides pre- and post-processing functionality that can be used to execute custom SQL around generated ETL/ELT processes. We are looking for an equivalent capability in Qlik Talend Data Integration.

In particular, our use case is to ensure that indexes can be automatically created or maintained on Transformation target tables after the Transformation task creates or refreshes them.

Could you please clarify:

• Is there currently a native pre/post SQL hook mechanism in Qlik Talend Data Integration?

• what is the recommended approach for executing SQL before or after a Transformation task?

• Is there a roadmap item for functionality equivalent to the pre/post processing available in Qlik Compose?

Thank you.

Hi Everyone,

I have 3 tables inside a Tabbed Container in Qlik Sense.

When I export the container to Excel, all 3 tables are exported into separate sheets. However, the table titles are missing in the Excel export.

Is there any way to include the table titles in the Excel export, either at the top of each sheet or as the sheet name?

Any suggestions would be appreciated.

Thanks!

Hello , I have a Button object in Qlik Sense . I want to display a tooltip text when hovering the mouse over the button (for example : display "Mobile" when hovering the Mobile button).

Hi Qlik Community,

I am attempting to integrate Qlik Cloud Automation with Slack Event Subscriptions to handle @mention queries using Qlik Answers.

However, I am stuck at the Slack Event Subscriptions url_verification step and unable to achieve Verified status.

Setup Overview:

1. Trigger: Triggered Automation (Start block set to Webhook/Triggered).

2. Verification Logic:

   • Condition block checks if Start > body > challenge is not empty.

   • YES branch: Routes directly to an Output block returning Start > body > challenge, immediately followed by a Stop block.

3. Authentication:

   • Slack Event Subscriptions does not allow sending custom HTTP headers (such as -H "X-Execution-Token: <TOKEN>").

   • Therefore, I am appending the token as a query parameter in Slack's Request URL: https://<tenant>[.qlikcloud.com/api/v1/automations/](https://.qlikcloud.com/api/v1/automations/)<automation-id>/actions/execute?X-Execution-Token=<TOKEN>

What Works:

• Sending a POST request via curl with the token in the HTTP Header works perfectly and returns the challenge string: curl -X POST "<URL>" -H "X-Execution-Token: <TOKEN>" -H "Content-Type: application/json" -d "{\"type\": \"url_verification\", \"challenge\": \"test_123\"}"

The Problem:

• When testing with query parameter authentication (which Slack relies on), the request fails with an HTTP 403 Forbidden error: {"errors":[{"code":"HTTP-403","title":"No permission.","detail":"You don't have sufficient permissions to access this resource."}]}

• We confirmed this 403 Forbidden response using Google Apps Script / UrlFetchApp when sending the token via query parameter (?X-Execution-Token=<TOKEN>).

Questions:

1. Does Qlik Cloud Automation support executing Triggered Automations when the X-Execution-Token is passed via URL query parameters (?X-Execution-Token=...) instead of HTTP Headers?

2. Is there a specific setting or URL format required to allow Slack Event Subscriptions to authenticate successfully without custom HTTP headers?

Any advice or workarounds would be greatly appreciated. Thank you!