Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 230,847 members
  • 3,613 online
  • 2,013,486 posts
  • 151,145 Solutions
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    Qlik Sense vs Power BI

    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 u... Show More

    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

    Show Less
  • forum

    New to Qlik Analytics

    ERD tables not associating

    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 b... Show More

    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? Screenshot 2024-09-14 165416.png

    Screenshot 2024-09-14 170132.png

    Show Less
  • forum

    Security & Governance

    How to obtain the last access date for users with Capacity license through Postg...

    Hello All, To retrieve data from the professional license, I am using the LicenseProfessionalAccessTypes table from the public schema through the Last... Show More

    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

    Show Less
  • forum

    Installing and Upgrading

    Target branch version mismatch after upgrading Studio to 2024-08 version

    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 earl... Show More

    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:

    MauerwegRunnerBerlin_0-1726126628907.png

     

    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

     

     

     

     

    Show Less
  • forum

    Move to SaaS

    Qlik Data Transfer - Select Files rather than entire Folder?

    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 ... Show More

    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?  

    Show Less
  • forum

    App Development

    Find common attribute to entries and assign it to all entries

    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 ... Show More

    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

    Show Less
  • forum

    Qlik AutoML

    Linear regression coefficient and intercept

    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... Show More

    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

     

    Show Less
  • forum

    Qlik AutoML

    R2 score - Normal R squared or multiple R squared or Adjusted R squared?

    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.W... Show More

    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?

    andres_kukke_1-1726267721211.png

     

    Show Less
  • forum

    Move to SaaS

    Data Transfer connections triggered from Cloud

    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 ... Show More

    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!

    Show Less
  • forum

    App Development

    Team Vacation Tracker

    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 clea... Show More

    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.

    Show Less
X
Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

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.

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!