Hi everyone,

I just published a new Data Voyagers video on Qlik Code, the Visual Studio Code extension that lets you edit Qlik Cloud load scripts in VS Code instead of the Data load editor.

I wanted to cover the whole thing in one place, so the video goes through each feature in order. Once you sign in to your tenant, you can browse spaces, apps, and scripts, then view, edit, and sync load scripts using direct or local editing. The editor supports the Qlik script language with syntax highlighting, completions, hover help, and diagnostics. You can also insert script content to load files from the data catalog or a data connection, or pull in existing script assets like QVS files. When you are ready to test, you can reload the app, preview your data, look at the data model, and open the app in Qlik Cloud from your browser.

A few limits from the documentation are worth knowing. Qlik Code is aimed at developers who already work in Qlik Cloud, and it does not replace the activity centers, so tasks like managing spaces, sheets, and app permissions stay there.

Watch the video here: https://youtu.be/8omcueKfuQ8

Documentation: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/QlikCode/code-extension-home.htm

I would like to hear how this fits your workflow. Are you already writing scripts in VS Code, or still in the Data load editor? Which feature would you use first, and what is missing for you? Tell me in the comments.

Regards,

Mark Costa

Hi everyone,

When configuring a notification in Talend Administration Center (TAC), the Mails selection dialog displays users’ email addresses in the Login column, but the Email column is empty, as shown in the attached screenshot.

When creating a user in TAC, I enter the email address in the Login field. However, the user creation form does not show a separate Email field.

Is this expected behavior? Should TAC also display the login email address in the Email column, or is there another setting required to populate it?

How does TAC determine which email address to use when sending notifications to the selected users?

Thanks

Your analytics applications already hold years of business logic. Now, you can reuse that work by extracting a data product from an existing application, making it governed, reusable, and discoverable.

What it is

Extract data product from application creates a new data product from an analytics application you’ve already built. The data product includes both the application’s data and a semantic model of its relationships, dimensions, and measures.

Why try it?

The business logic you’ve already built can now do more. Extraction brings your application’s relationships, dimensions, and measures into a governed data product, giving them a shared, reusable home. This lets you use existing work, rather than recreate it manually.

Get started

Start with an existing application.

1. Open the application details or use the application’s contextual menu in the catalog.
2. Select “Manage > Extract and create data product”.
3. Name the data product, choose a space, and extract.
4. Review the log to see what was extracted.
5. Open the new data product and check its semantic model.

Your original application stays as it is, and you can keep using it.

To extract, the application must be in a personal or shared space, and you need the “Can edit data in applications” permission. Extraction runs a script that creates new datasets as data files in Qlik Cloud, so consider the size of your application first.

For the full steps, see Qlik Help | Extracting data products from analytics applications.

To learn more about semantic models, see Qlik Help | Semantic models in data products.

What to know before you try it

This capability is in Public Preview, and there are a few limitations to keep in mind:

• Applications that use section access are not supported.
• Applications in managed spaces are not supported. Move or copy the application to a shared or personal space first.
• Extraction doesn’t carry over cyclic and drill-down dimensions.

How to enable the preview

Feature previews must first be enabled for your tenant, and your tenant admin needs to grant you access via the “Feature preview” permission. If you don’t see Feature previews in your profile, check with your tenant admin, as described in Managing feature preview for your tenant.

Once you have access, go to your “User profile > Feature previews” and activate the “Extract data product from application” preview feature. See Feature previews for details on how the program works.

Share your feedback

Use the in-product feedback button, either in the Feature previews dialog or when clicking on the “Preview” badge available in the “Extract to new data product” dialog.

We’re especially curious about:

• How does the extraction flow work for you, and did you expect something different?
• How does extraction behave on larger or more complex applications?
• What did you expect to find in the data product that wasn’t there?

I'm pretty new to Talend Studio and building pipelines with it and I've got a confusing situation.

I need to pull the three main fields from an HTTP Response (headers, status, body) and store them in a database (for audit purposes).  However, I also need to dive into the body of the response (which will be Json), find a specific tag (a metadata tag), and capture two fields from this metadata tag.  With both outputs, I then need to combine it into one and save an audit record to a database.

I know how to work with either the tJavaRow (to get the header, status, and body fields) and the tExtractJsonFields (to get the metadata).  What I'm having an issue with is combining these two outputs back together and then saving it to the database.  Every route to do this seems either overly complicated (trying to do some Java package imports and writing even more custom Java code) or is just flat-out not allowed by Talend Studio because you can't tUnion or even tMap from the 'same source' back together.

Is there a simpler way to do what I'm wanting?  For example, my HTTP response might be:

{"headers": "someheaders", "status": 200, "body": { "meta": { "field1": "value1", "field2": "value2"}}}

And I need to capture it into my database like this

headers -> someheaders

status -> 200

field1 -> value1

field2 -> value2

Hi everyone,

We are experiencing an OAuth 2.0 authentication issue when trying to connect Qlik Cloud Analytics to Salesforce using the Salesforce connector from Add Data.

A new Salesforce External Client App was created following Salesforce's recent security changes.

According to Salesforce's updated security requirements, PKCE is mandatory for newly created applications, and the option to disable it is locked.

However, the Qlik documentation instructs us to disable PKCE as part of the connection setup.

We attempted to configure the Salesforce Callback URL using both:

https://connector.qlik.com/auth/oauth/v2.htm

https://connector.qlik.com/auth/oauth/v3.htm

Both attempts failed during authentication, resulting in the following errors:

redirect_uri_mismatch

OAUTH_APPROVAL_ERROR_GENERIC

We would appreciate hearing from anyone who has encountered a similar issue or has successfully established a Salesforce OAuth 2.0 connection in Qlik Cloud Analytics under the new PKCE requirements.

Thanks in advance for sharing your experience!

Join Qlik Support's office-hours, recorded live, where our experts answer your questions and give more insight on Reporting.

Questions:

1. 02:42 - Will pivot table adjustments be added directly to reports?
2. 04:44 - Can the email attachment file name be dynamic?
3. 06:18 - How to filter import in Qlik Cloud Reporting?
4. 07:47 - How to set CC and BCC in Qlik Cloud Reporting?
5. 11:12 - What are best practices in Qlik Cloud Reporting?
6. 12:12 - Are there any special PowerPoint themes in Cloud?
7. 13:59 - How to develop visuals for PowerPoint in Cloud?
8. 16:12 - Will CSV exports be a new feature?
9. 17:02 - Any tips for fitting charts in PowerPoint?
10. 17:38 - How to customize the attachment timestamp?
11. 19:22 - Can Qlik Automate customize the timestamp format?
12. 20:36 - Is there an option to not send if there is no data?
13. 21:28 - How to define the recipient groups?
14. 23:42 - How to see what is on development on the roadmap?
15. 24:25 - How to migrate from NPrinting to Qlik Cloud?
16. 26:02 - How to make the file name dynamic?
17. 27:43 - Will it be possible to export to Google Sheets?
18. 28:50 - How to adjust the file size?
19. 31:26 - How to limit who can run reports?
20. 33:54 - Is there a guide for Pixel Perfect reports?
21. 36:12 - Can reports be triggered after a condition is met like alerts?
22. 37:00 - Is there documentation on using Qlik Automate for reports?
23. 38:48 - How to monitor reporting tasks?
24. 40:00 - How to schedule on the first workday of the month?
25. 41:15 - Will reporting block in Qlik Automate be updated?
26. 41:28 - How to filter recipients inside Qlik Automate?
27. 43:06 - Is there an ideal page size for visuals in PowerPoint?
28. 44:08 - Is there a guide for how to generate reports?
29. 46:20 - Can alerts be sent if a report fails to send?
30. 47:58 - How to limit who can run an automation?
31. 49:20 - Can Qlik Answers run reporting tasks?
32. 50:17 - Is Pixel Perfect a good alternative for reports?
33. 52:07 - Are there themes that are optimal for reporting?
34. 52:33 - Can we overlay multiple charts in the same space?
35. 53:59 - Can one report come from multiple apps
36. 54:55 - How to filter reports by recipients in Automate?

Resources:

• Qlik Ideation Portal
• Techspert Talks: Migrating To Qlik Cloud Analytics
• Creating report filters
• Creating a distribution list for your report
• Qlik Help: Reporting from Qlik Cloud Analytics with Qlik Automate
• Generate a report using Qlik Application Automation
• Limitations for reporting with Qlik Automate
• Best practices for in-application reporting
• Qlik Learning: Introduction to PixelPerfect Editor & Tabular Reporting
• Playlist: In app reporting with Qlik Cloud Analytics
• API: Get report request processing status
• Techspert Talks: Qlik Cloud Reporting Evolution

Did we answer your question? Let us know by clicking the like button!

Click here to see video transcript

@Andrea_Bertazzo 

@Frank_S 

@Vinay_B 

Hi team,

Need one suggestion in qliksense +(nprinting)

We have dynamic view chart in qliksense dashboard but as we know that nprinting is not supporting dynamic views..

What can be work around to extract dynamic view chart in pdf

I tried

1: creating a story then export
2: sheet export as pdf
3: extension+ mash-up

No success with option 1 & 2
With option 3 I achieve it, but not good and dynamic solution for all dashboard who have dynamic view charts.

Thanks in advance!

Regards,

Prashant

I'm getting very confused over looping and grouping in the data mapper (which I would be calling via a tHMap in a regular Data Integration job).

In essence we are receiving digital files for archiving, with a set of CSV metadata files which describe various aspects of the records. This metadata needs to be reformatted (joining data from across the original metadata files) and transformed, ultimately producing a set of JSON files, one per transferred digital file, so that we can send these (plus the digital files where appropriate - some files are restricted from public access for a set period so in that case we send only the metadata). Within this there can be multiple reasons why a file has public access restrictions, in the original metadata these are provided as a semicolon separated list within a single field. Independently of the access restrictions, there can also be a list of catalogue references to provide information about particularly close relationships between records. Similarly these are also provided as a semicolon separated list.

For the output JSON we have a JSON schema so I've created a structure from that (though this covers a wider range of use cases than is likely to occur in our particular usage, so some potential output fields wouldn't actually receive and data as we don't have appropriate data to put into them).

To try and create the input structures, I linked rows to the tHMap in the data integration job, the main row has normalised data with the list of reasons for an access restriction split out into individual values, with the other values repeated. There is an id value which acts as a key, so in the hierarchy these should be grouped together with the access restriction reasons going into an array.

Then there's a lookup with the normalised data for the relationships to other records, again these have the record id associated with each row in the lookup.

I think one problem may be that the structure for the output is based on a single record, but we have multiple records coming in on the other side, so I guess I either need to iterate over individual records somehow on the input side, or and a wrapper on the output, and then figure out how to split it up into individual JSON files, one per record later in the main job?

Then I can't figure out how to set up the looping and grouping so that this all comes together as required.

I can provide some screen shots of what I've got so far, or some (slightly simplified) example data which preserves the main points of what I've described above, but doesn't include every field in the actual data we're processing as there's rather a lot, and most of it doesn't have any bearing on the looping and grouping.

I hope this makes some sense: I'm a bit sleep deprived today too, which isn't helping.

Thanks