Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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>:
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
{
"audience": "auth0saml",
"logout": {
"callback": "https://<your_server_url>:443/sso/samlauthn/slo/",
"slo_enabled": true
}
}
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):
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?
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
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!