Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I know pretty well the differences between Qlik Sense and Tableau. I develop more in QS and am biased towards it, but I get why Tableau is so widely used. QS works better for my org since it is much faster at rendering visualizations when filtering lots of data and the associative data model is super powerful for our use cases.
I have limited experience developing in power BI. Is there a load script? Can you do pretty much the same things? Does it's data model work at all like Qlik's? I'm always seeing it at the top of that Gartner quadrant thing and wonder if I should take time to learn it in case MSFT eats Salesforce and Qlik's lunch
I'm learning to use Qlik and have uploaded a dataset from Xcel given to me by the course provider. The Products table and Orders table are meant to be linked via the ProductKey, however they've appended their sheet name to the front in each table. I've tried to manually associate them in the data manager, but it isn't working. I'm 99% certain this failure to link is the issue in my dashboard charts. Can anyone help me to figure out how to fix this?
Hello All,
To retrieve data from the professional license, I am using the LicenseProfessionalAccessTypes table from the public schema through the LastUsed field.
SELECT User_ID, LastUsed FROM public.LicenseProfessionalAccessTypes
Similarly, to obtain data from the analyzer license, I am using the LicenseAnalyzerAccessTypes table from the public schema through the LastUsed field.
SELECT User_ID, LastUsed FROM public.LicenseAnalyzerAccessTypes
However, when attempting to obtain the last access for the capacity license, I couldn't identify which table to query.
Can someone help me with this question?
Thanks
Leandro Godek
Hello,
We use Talend Data Integratio on premise. With GIT integration. The studio has now been migrated to 2024-08. The previous version was from early 2024 (02 I think).We have activated Java 17 and the studio appears in the new design.
All existing local branches can be migrated and run.
However, creating a new branch from the main branch results in the following error message:
The question now is how the project can be migrated. We've additionally migrated the job server. But this should not affect the GIT and project migrating.
A push of an already migrated local branch works fine.
Thanks in advance
The question now is how the project can be migrated.
A push of an already migrated local branch runs successfully. Which is also surprising, as the local version is more up-to-date.
Thanks in advance
Matthias
When using Qlik Data Transfer, is it possible to select only a single file (or a few selected files) within a folder, rather than the entire contents of the folder?
Use case: another department provides a shared excel file in a folder. That folder contains other files that we do not want to sync to Qlik Cloud, and moving the file is not an option since it is used by other processes. We want to reference that file in a Qlik Saas Analytics app. My understanding is that we can use QDT to copy the entire folder, but not just select a single file from a folder.
If not QDT, what other options are there for Qlik Sense Saas to use an on premise file in the load script?
Hello,
I have 2 tables:
[BOM list]:
LOAD
[Bill of material],
[Part]
FROM BOM_list.xls
and
[Part List]:
LOAD
[Part],
[Attribute]
From part_list.xls
Each part in [Part List] can have different attributes, example of data:
Part, Attribute
A, small
A, medium
B, medium
B, big
C,small
C,medium
C,big
Example of data in [BOM List]:
Bill of Material,Part
1,A
1,C
2,A
2,B
2,C
I want to find for each [Bill of material] of table [BOM list] the only common attribute for each part.
Example of expected result in a third table:
Table3:
Bill of Material,Attribute
1,small
2,medium
I know I will always have only one attribute which will be common to all parts of a given bill of material. But just in case it would be acceptable if Table 3 contains multiple entries for a given Bill of material in case there are two attributes which are common to the list of part of that BOM.
Thank you for your help
Hei!
I buliding model to predict market price. I made experiment and best model was linear regression with 4 features. I trained same model in R-Studio using also linear regression (function lm())
Qlik AI gives highest R-square (0.65 vs 0.59 in R-Studio) into same sample (also same number of features)
I was curious to find out regression coefficient and intercept. In R-Studio I can get coefficients using syntax: summary(my_regression_model).
Residuals:
Min 1Q Median 3Q Max
-10.4651 -1.5801 -0.3867 1.4452 9.1223
Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) -6.6118 2.1749 -3.040 0.00367 **
Volume 6.4781 1.2279 5.276 2.50e-06 ***
SalesABC 0.8449 2.2853 0.370 0.71308
Corrosion 3.2238 1.1819 2.728 0.00863 **
Quality 4.4110 0.9713 4.541 3.26e-05 ***
Volume:SalesABC -1.7214 1.1693 -1.472 0.14690
Volume:Corrosion -1.4987 0.8246 -1.817 0.07480 .
SalesABC:Corrosion -0.9049 1.0123 -0.894 0.37543
Volume:SalesABC:Corrosion 0.4691 0.6139 0.764 0.44814
---
Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1
Residual standard error: 3.225 on 53 degrees of freedom
Multiple R-squared: 0.645, Adjusted R-squared: 0.5914
F-statistic: 12.04 on 8 and 53 DF, p-value: 1.323e-09
How can I get regression model coefficients and intercept in Qlik AI?
I can get out SHAP values qvd (or csv file) but those are different than regression coefficients.
Does Qlik AI supports "explainable AI" concept?
Andres
Can anyone have correct definition which R2 square Qlik AI is presenting?
I used R Studio and there are two R-square metrics - multiple and adjusted.
What is exact R2 definition in Qlik AI model having (in column labeled "R2")? Just regular R2 or adjusted R2 or multiplied R2?
I'm working with Qlik Cloud and I need to trigger data transfers from Qlik Cloud to a local server using Qlik Data Transfer. Specifically, I want the transfer process to start automatically after a certain action is performed within a Qlik Cloud application, such as a reload.
How can I configure Qlik Cloud or use Qlik Application Automation to trigger the data transfer and ensure that the local server gets the updated data?
Any insights or guidance would be greatly appreciated!
I’m trying to create a visualization in Qlik Sense/QlikView that displays my team’s vacation days over the year. The goal is to give my manager a clear view of available resources for workload management.
We don’t currently have any Gantt chart extensions.
Could anyone suggest alternative chart types and approaches to effectively represent this vacation data in Qlik?
I’ve attached a sample of our data and a screenshot of how we’re currently visualizing it in Google Sheets.
Pencil in our most magical conference yet: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL
Fuel your data and AI journey with the right services, delivered by our experts.
With Qlik Answers™, get personalized, GenAI-driven answers from unstructured data, so you can make decisions with confidence. Learn how in our product roadmap keynote and demo.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.
Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
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!