Join Qlik Support's office-hours, recorded live, where our experts answer your questions and give more insight. This month's topic is: New to Qlik Cloud

Questions:

1. 02:04 - What course is recommended for a Qlik Cloud Analytics certification?
2. 03:27 - How to move ETL/ELT scripts to a cloud capacity model?
3. 07:38 - How to simplify the assignment of roles and entitlements?
4. 10:03 - How to embed Qlik objects?
5. 11:54 - Any plans to remove the need for classic mode when embedding?
6. 13:26 - In a simple table, how to make my selections available for download?
7. 16:02 - Will there be a FileMakerDB connector in the near future?
8. 16:55 - Can Qlik Cloud make an ODBC connection?
9. 18:05 - How to properly size how much data is needed in cloud?
10. 20:49 - Is Qlik Replicate available in Qlik Cloud?
11. 22:25 - What learning modules are there for using AI in data integration?
12. 24:09 - How to add hyperlink in an Excel column with on-demand reporting?
13. 25:35 - How to restrict access to the app while allowing anonymous embedding?
14. 27:02 - How to evaluate the amount of capacity needed?
15. 27:58 - Is there a reload monitoring tool available in Qlik Cloud?
16. 29:14 - How to migrate NPrinting to Qlik Cloud?
17. 30:40 - Can AI tools be used with Qlik On-Prem?
18. 32:00 - Is there a demo showing AI in Qlik Cloud?
19. 33:16 - What if we want to use AI, but not move to Cloud?
20. 34:39 - Can we download CSV, XLSX, etc files from Cloud spaces?
21. 36:52 - Are now connections for Replicate being developed?
22. 37:59 - Can QlikView customers test out Qlik Cloud?

Resources:

• Qlik Certifications
• Qlik Cloud Admin 101
• Qlik Cloud Admin 201
• Embedding Qlik Analytics in SharePoint
• Qlik Dev: Qlik Embed
• Qlik Ideation
• Understanding Set Analysis
• Troubleshooting Qlik Data Gateway Direct Access
• ODBC databases connection documentation
• Qlik Migration Center
• Migrating Qlik Sense Client-Managed To Qlik Cloud
• Migrating To Qlik Cloud Analytics - Tool
• Qlik's Move to Cloud Learning Page
• Migrating QlikView to Qlik Cloud
• Qlik Talend Cloud: Setting up connections documentation
• Learning: Using AI Components in Talend Studio
• Learning: Qlik Talend Cloud - Knowledge Marts
• Qlik Cloud Reporting Evolution
• Qlik Explore

@DikshaBhosle 

@Umberto 

@Vinay_B 

@SwathiPulagam 

Hi everyone,

Using this code blow :

WeekName([Calendar date],0,-4)

I got the last week of the year 2025 from 25 december to 31 december 2025 as the 1st week of the year 2026 instead of the last year.

I tried this code below, but it didn't work:

if(       date <= date('31/12/2025', 'DD/MM/YYYY') AND date >= date('25/12/2025', 'DD/MM/YYYY')         
        ,        53,
       if(date <= date('01/01/2026', 'DD/MM/YYYY') AND date >= date('07/01/2026', 'DD/MM/YYYY') 
       ,1,Week(date, 0, -4)-1 )

Is there another way to solve this? Thanks in advance.

Hello,

Hi,

I am trying to load context variable value from file data, getting null value. I don't want load File data via any talend components. Please check & suggest.

File Name : test.properties

File Data:

kafkaUser=testUser

Hi All,

I have quite new to Qlik. I want to create 4 fields (SUM_1, SUM_2, SUM_3, SUM_4) to count distinct ID meets criteria by category. May I ask how to create 4 expressions in front end.

Criteria:

Existing table:

Target Table:

Hi,

Talend Studio

Is it possible to re-open the merge results dialog without re-doing the merge?

Thanks

Hello,

Can anyone please help me how can i get filter below data sets into two outputs using QLik.

Sample Data:

Date            ID      Amount
1/1/2025    AAA       2
2/1/2025    AAA       5
12/1/2025  AAA       2
12/1/2025  AAA       5
12/1/2025  AAA       2
23/1/2025  AAA       2
24/1/2025  AAA       5

Output1
Date            ID     Amount
1/1/2025    AAA       2
12/1/2025  AAA       2
12/1/2025  AAA       2
23/1/2025  AAA        2

OutPut2
Date           ID     Amount
2/1/2025    AAA      5
12/1/2025  AAA      5
24/1/2025   AAA      5

Thanks in Advance

I have a SQL Server source table that has 5 columns: 

1.  3 non-nullable INTEGER columns
2.  1 non-nullable DATETIME column that records the database insert date 
3. 1 nullable DATETIME column that records the update date

The MERGE statement looks like this (the names were changed to protect the innocent): 

MERGE INTO "dbo"."my_table_name" T
USING (
SELECT *
FROM "public"."attrep_changes6004D92ED521268C"
WHERE "table_id" = 1
) S
ON (T."ASSIGNMENTID" = IFF("table_id" = 1, TRY_CAST(S."seg1" AS NUMBER(38, 0)), NULL))
AND (T."PERIODID" = IFF("table_id" = 1, TRY_CAST(S."seg2" AS NUMBER(38, 0)), NULL))
WHEN MATCHED AND "replicate_op" = 0 AND "table_id" = 1
THEN DELETE
WHEN MATCHED AND "replicate_op" <> 0 AND "table_id" = 1
THEN UPDATE SET
T."NumericColumn1" = IFF("table_id" = 1, TRY_CAST(S."col1" AS NUMBER(38, 0)), NULL),
T."NumericColumn2" = IFF("table_id" = 1, TRY_CAST(S."col2" AS NUMBER(38, 0)), NULL),
T."NumericColumn2" = IFF("table_id" = 1, TRY_CAST(S."col3" AS NUMBER(38, 0)), NULL),
T."DatabaseInsertDate" = IFF("table_id" = 1, TRY_CAST(S."col4" AS TIMESTAMP(3)), NULL),
T."DatabaseUpdateDate" = IFF("table_id" = 1, TRY_CAST(S."col5" AS TIMESTAMP(3)), NULL)
WHEN NOT MATCHED AND "replicate_op" <> 0 AND "table_id" = 1
THEN INSERT (
"NumericColumn1",
"NumericColumn2",
"NumericColumn3",
"DatabaseInsertDate",
"DatabaseUpdateDate"
)
VALUES (
IFF("table_id" = 1, TRY_CAST(S."col1" AS NUMBER(38, 0)), NULL),
IFF("table_id" = 1, TRY_CAST(S."col2" AS NUMBER(38, 0)), NULL),
IFF("table_id" = 1, TRY_CAST(S."col3" AS NUMBER(38, 0)), NULL),
IFF("table_id" = 1, TRY_CAST(S."col4" AS TIMESTAMP(3)), NULL),
IFF("table_id" = 1, TRY_CAST(S."col5" AS TIMESTAMP(3)), NULL)
);

I figured that the issue is caused by TRY_CAST and that the TRY_CAST is returning a NULL for my DatabaseInsertDate.   The FULL load works fine, but from what I can see the full load is doing a COPY INTO and not running a TRY_CAST.  I have tried adding a transformation on the Table Settings for this table to 

strftime('%Y-%m-%d %H:%M:%f', $DatabaseInsertDate) 

...but that has not helped. 

The public.attrep_changes6004D92ED521268C table goes away as soon as the error occurs so I cannot see the data behind the issue.  

Please help.  Thanks

Hello all

I have a button in my Qlik Cloud app that executes an automation in triggered mode. When I publish the app to a managed space so that end users can trigger it themselves, they click the button, but the automation won't be executed.

It seems like only the owner of the automation is allowed to execute it.

I did everything in this video: https://youtu.be/uwtpmjumejc?si=9kLwfiOoab4Ywhr0 in manual mode and trigger mode, also nothing.

How can I resolve this? Also is this a limitation of the Analyzer License?

Thanks

Important Update: The automation trigger works inside the tenant but not in the embedded app. I forgot to mention that I'm embedding the app inside and iframe in my web app, and I think the limitation comes from this.