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.

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?

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.

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?

Hi,

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

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

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

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

___________________________________________

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?

Hi Community!

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

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

Have you any ideas?

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 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:

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:

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

I hope you can help me.
Thank you very much