Hello everyone, i'm having issues trying to create a canonical date in qlik sense when associating tables and was wondering if anyone would be able to help out. In basic terms i have 2 tables: "orders" and "sales rep visits", which are associated to the "customer data" table by customer number, (very simplified) script below:

Hello.  I'm sorry as I'm sure this question is asked a lot but I wanted to get everyone's opinion on the best way to learn Qlik Sense. Here are the questions I have:

1) Data Transformations - I'm used to performing data transformations using Power Query which visualizes the data and has a drag and drop interface.  From my limited research, it looks like Qlik uses a scripting language to transform data prior to integrating it into a data model.  This seems like it will require a good amount of time to learn.  Is it better to spend that time learning the QLIK Scripting language or should I just learn how to do it in SQL and then bring in the data?  I am sure there are pros and cons to both but in the short-term I'm probably only going to bother learning one and I wanted to know what is preferred among Qlik Users?

2) Training - What courses have people used to learn Qlik Sense?  Are there known youtubers?  I saw Qlik Sense has a free business analyst video set.  I watched a few introduction videos and most of it is pretty intuitive.  

The two areas I'm struggle with is understanding how filtering works in Qlik Sense but I think I just need more practice playing with data.  The big area of focus is to understand the lexicon (what functions are available in Qlik Sense, how they work) and the syntax in Qlik Sense so I can write functions/play around with it.   

Thank you for your time!  

Hi Experts,

I have a loop automation that runs continuously until the timeout of 14400 seconds.

The automation fails few seconds before the 4 hours limit, so when the schedule time arrives it should be executed again.

The problem is that the automation skips some executions during the day without any errors or log file.

Is this a bug?

Best Regards,

Michela

Hi team,

I have filter, In that i have some values.

Eg:

A

B

C

D

if I select A and B its to display sum(Sales)

If I select A and B and C etc its to display count(Sales)

For Particular Selection, I need to show one measure,

If extra anyone Value is added in the filter it should show other measure...

Thanks in Advance

TLDR : I want to access an Excel file based on a sharepoint path I give manually.

What I've tried : you can give to a "Open file on Microsoft Sharepoint" component a path directly linking to a document, and then use a "Read Data From File on MS" to open it but it only works for CSV and JSON documents. 

You can also acces the document based on a Drive ID and Item ID with a "List Rows With Headers" for example. This solution however needs me to access every item of the file tree until i get to the file containing the excel wich is not really sustainable. 

So I would need a component that either open an xlsx document based on a path or give a Drive ID and Item ID based on a path.

Any other idea would help.

Thanks in advance,

Maxim Perolle

Hi Team,

We are getting below error in a task.

Could you please help us with the same.

SYS-E-HTTPFAIL, Cannot connect to sql server.
SYS,General_Exception,Cannot connect to sql server , sqlstate:08001 NativeError:-2146893016 Message:[Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The received certificate has expired.

Task Name replication task encountered the following error:
Creating Metadata Manager's utility components failed Cannot create the target utility component failed while preparing stream component 'Task Name'.
Cannot coonect to SQL Serv
RetCode: SQL_ERRO SqlState:08001 NativeError:- 2146893022 Message:[Microsoft][ODBC Driver 18 for SQL Server]SSL Provider:The target principal name is incorrect.

Regards

Mrunal

Hello,

I have this load script for one of my app in Qliksense.

Table1:

Load

First_Name,

Last_Name,

Salary,

Fiscal_Year

SQL Select

FirstName as First_Name,

LastName as Last_Name,

Salary,

FY as Fiscal_Year

From XYZ_Table

In the sheet, I have this simple table with Fiscal_Year column that shows all the data for all the years.

User requested to filter the data to only shows the current year and two previous years. I have adjusted my code to this:

Table1:

Load

First_Name,

Last_Name,

Salary,

Fiscal_Year

SQL Select

FirstName as First_Name,

LasrName as Last_Name,

Salary,

FY as Fiscal_Year

From XYZ_Table

WHERE Fiscal_Year >= (YEAR(GETDATE())-2);   //to get only year 2024 and 2023,2022//

It loaded successfully and I got no errors, but when I go to my table in the sheet, I still see years from 2016-2021

I am not sure what I am missing. Could someone please help me with this?

thank you!

Hello

We have a Qlik CDC only task and we performed a modification on a filer transformation on a table.

We stopped that task , perform Import task with the desired modifications and perform (for mistake) resume processing of the same task.

The filer was loaded correctly (and unexpectedly !)

We remember in the past documentation that , if we have to perform a filter modification, we are aware that we will perform stop+import of the task (or perform modification by Qlik Enterprise Manager GUI and save the currently running task) and perform reload target

Can you explain us what happened ? in what case resume processing is acceptable for filter modifications scanarios ?

Lt us know

Regards

Alessandro Ferrario

Hello,

I want to remove a colum from dynamic type input in tjavarow.

I tried this but it didn't work :

Dynamic dyn = row3.table;

dyn.removeColumn("NameColonneToDelete");

Can anyone help me ?

Thanks