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,

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.