Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,
Megha
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
Data Quality, Preparation & Stewardship
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
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!