Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 230,473 members
  • 11,788 online
  • 2,012,948 posts
  • 151,100 Solutions
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    Qlik Truncate String Length

    Hello! I have a connection with Databricks, where I have a table with the geographic coordinates of Brazilian states. However, this data is a string w... Show More

    Hello!

    I have a connection with Databricks, where I have a table with the geographic coordinates of Brazilian states.

    However, this data is a string with many characters, and Qlik is only loading 255.

    Is there any way around this?

    I have already set the connection parameter to 16384 as the maximum string size, but it continues to get 255.

    Show Less
  • forum

    New! Qlik Answers

    Exploring Qlik Compose for Data Warehouses: How to Convert T2 Dim to T1? | Julio...

    Hello, I’m Julio Herrera from Via Dei Velutini, Italia. I’d like to share some information and need your assistance. Can you please explain the steps ... Show More

    Hello, I’m Julio Herrera from Via Dei Velutini, Italia. I’d like to share some information and need your assistance. Can you please explain the steps to convert a T2 (Type 2) dimension to a T1 (Type 1) dimension in Qlik Compose for Data Warehouses? Additionally, what are the key considerations and potential impacts of this conversion on the data warehouse?

    Show Less
  • forum

    Deployment & Management

    Tutorial: Configure Auth0 as SSO for Qlik Sense Enterprise for Windows using SAM...

    Hi there,We recently configured Qlik Sense to work with Auth0 (the free version works) and use the internal Auth0 user database for authentication/SSO... Show More

    Hi there,

    We recently configured Qlik Sense to work with Auth0 (the free version works) and use the internal Auth0 user database for authentication/SSO and thought we'd share the process.

    The steps to get started with an initial connection are as follows, for an example single-node installation (be sure to replace the <your_server_url> with your Qlik Sense server URL - example https://server.example.com/hub/ use server.example.com as <your_server_url>:

    1. Create a new virtual proxy in Qlik Sense from within the QMC
    2. Enter the description ‘Auth0’
    3. Enter ‘sso’ in the prefix field
    4. Set Session cookie header name to ‘X-Qlik-Session-Auth0SSO’
    5. Add new server node and select your ‘Central’ node and click Add
    6. Check ‘Authentication’ and ‘Advanced’ on the sidebar
    7. Choose ‘SAML’ as authentication method
      1. Tick SAML single logout
      2. SAML host URI is the URL of your Qlik Sense Server (ending in a /)
      3. SAML entity ID is ‘auth0saml’
      4. SAML attribute for user ID is ‘http://schemas.xmlsoap.org/ws/2005/05/identity/claims/emailaddress’ to use email address
      5. SAML attribute for user directory is [auth0] for a static directory
    8. In the Host white list, click Add new value twice and enter both the URL of your Qlik Sense Server in one row (without https:// or / at the end) and ‘auth0.com’ in the other
    9. Click Apply
    10. Link the Virtual Proxy to the Proxy by clicking on ‘Proxies’ in the sidebar under ‘Associated Items’
    11. Click ‘Link’ and select the Central Node and click ‘Link’ again

    At this point you have the following information in Auth0 terms:

    Application Callback URL: https://<your_server_url>:443/sso/samlauthn/
    SLO (Logout Callback) URL: https://<your_server_url>:443/sso/samlauthn/slo/
    Audience:  auth0saml

    1. Set up an Auth0 tenant
    2. Go to Applications > Create Application
    3. Enter a name and choose Regular Web Applications
    4. Go to Addons tab and click the red icon next to SAML2 Web App
    5. In the popup window enter the Application Callback URL ‘https://<your_server_url>:443/sso/samlauthn/’ in the Application Callback URL field
    6. Enter the following in the settings field:

    {

      "audience": "auth0saml",

      "logout": {

        "callback": "https://<your_server_url>:443/sso/samlauthn/slo/",

        "slo_enabled": true

      }

    }

    1. Scroll down and click Enable, then when saved, close this window.
    2. Make sure the SAML2 Web App is toggled on (green toggle) and click the icon again to display the popup once again
    3. Go to the Usage tab, and click ‘Download’ next to ‘Identity Provider Metadata’ to download an XML file used to configure Qlik
    4. Go back to the Qlik Sense server Virtual Proxy and edit the virtual proxy ‘Auth0’ you created
    5. Next to ‘SAML IdP metadata’ click on Choose File and select the downloaded XML file from Auth0 from step 9
    6. Click Apply and OK to restart Qlik Proxy

    You can then test by visiting  https://<your_server_url>/sso

    It should redirect you to Auth0 login page, then after login, back to the hub. You can then log out of Qlik, and it will sign you out of both Qlik and Auth0 and return you to the login screen.

    Show Less
  • forum

    New to Qlik Analytics

    How to load a SQL statement in the load editor?

    I just established a connection to my desired Teradata server. I have a SQL statement already created and I want to be able to use it in the load edit... Show More

    I just established a connection to my desired Teradata server. I have a SQL statement already created and I want to be able to use it in the load editor so that all my changes/manipulation to the data appear in the table. Can I paste or insert my SQL statement into the load editor script so that it returns the results?

    Show Less
  • forum

    Connectivity & Data Prep

    Error in selecting data for ODBC database using Qlik Data Gateway direct access

    Hi, I'm facing the below error, trying to select database table using Qlik Data Gateway direct access. ODBC source: iSeries Access ODBC Driver Connec... Show More

    Hi,

    I'm facing the below error, trying to select database table using Qlik Data Gateway direct access.

    agigliotti_0-1697123528293.png

    ODBC source: iSeries Access ODBC Driver

    Connection string: System=XXX;Uid=YYY;Pwd=ZZZ;

    Test connection is ok

    Also the manual select in DLE works correctly.

    Can someone help me to fix it?

    Many thanks in advance for your time.

    Best Regards

    Show Less
  • forum

    Qlik Replicate

    Not able to open qlik replicate- End of Stream

    Hi Team, I am not able to open qlik replicate console. It says SYSTEM-E-HTTPFAIL END OF STREAM Please help us to resolve the issue. Regards, Sushant
  • forum

    App Development

    Receive 'ErrorCode.4004' in connection with INTERVALMATCH

    Hi,   I'm trying to assign a date (only one line in the calendar) to a period (approx. 400,000 lines) with the following statement: LEFT JOIN ( MyData... Show More

    Hi,

     

    I'm trying to assign a date (only one line in the calendar) to a period (approx. 400,000 lines) with the following statement:

    LEFT JOIN ( MyDataTable ) INTERVALMATCH ( Date ) LOAD
    DateFrom,
    DateTo
    RESIDENT MyDataTable;

    and get the error message 'ErrorCode.4004' (not more).

    Any idea and solution about this?

    Best regards

     

    Christian

    Show Less
  • forum

    Move to SaaS

    How to disable Insights in new Cloud UI?

    With the new UI there are two options now for Analyzer users, Insights and Analytics.   ___________________________________________ Unfortunately th... Show More

    With the new UI there are two options now for Analyzer users, Insights and Analytics.

    p0cket0m_0-1725982993678.png

     

    ___________________________________________

    p0cket0m_1-1725981861467.png

    Unfortunately the button 'Insights' does not deliver any added value for us. Since more or less the same functionality is offered within the new 'Insights' tab as we have already it in 'Analytics', it's just redundance. 

    This confuses not only our users, also we admins don't understand it why 'Insights' is in first position. And the Insights "Browse" seems to be exactly the same like function like "Catalog" in Analytics??? The only difference seems to be the naming and the + Create button? We don't get it. 

    How can we disable Insights from the menu?

    Show Less
  • forum

    QlikView App Dev

    How to create Dynamic values in dimension

    Hi Community! I need to get table with dynamic values depend on dates (Customer Name must be change): Dim Expr DateBegin Sum(Sum_DateBegin) Cus... Show More

    Hi Community!

    I need to get table with dynamic values depend on dates (Customer Name must be change):

    Dim Expr
    DateBegin Sum(Sum_DateBegin)
    CustomerName_Top1 Sum(Sum_DateBegin) - Sum(Sum_DateEnd)
    CustomerName_Top2 Sum(Sum_DateBegin) - Sum(Sum_DateEnd)
    DateEnd Sum(Sum_DateEnd)

     

    I tried to use ValueList in dimension and pick(Match(ValueList(...))) in Expression, but I have error.

    Have you any ideas?

    Show Less
  • forum

    Qlik Application Automation

    Problem with selections

    Hello everyone,I have a group of scenarios that correspond to different sections of a highway as can be seen in the following table: I have an expres... Show More

    Hello everyone,
    I have a group of scenarios that correspond to different sections of a highway as can be seen in the following table:

    alexdelagarza_1-1725981194433.png

    I have an expression that should return the records that are at the intersection of scenarios 204 and 208, but it returns records from other scenarios as well, such as 104, 107, 108, etc., as can be seen in the following table:

    alexdelagarza_3-1725981372989.png

    This is the expression:

    =count( {$<ID_CARD= P({<Escenario2={'208'}>})*P({<Escenario2={'204'}>})>} ID_CARD )

    If I use the filters and select only the scenarios I want, I get the result I expect:

    alexdelagarza_4-1725981514526.png

    But, I need you to give it to me without using the filters.


    I hope you can help me.
    Thank you very much

    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!