Everything you need to make your Qlik Community experience valuable.
Explore official Support and member created content.
Seven Data Integration and Quality Scenarios for Qlik and Talend Solutions.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.
Get started on Qlik Community, find How-To documents, and join general non-product related discussions.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.
Hi All,
I have two fields - description and search fields, we have to find the value from Search String column
Example first records 100_QV_BCA_Test and if it is any word available in search string field I have to display (3rd column is my output column)
Description | Search String | OutPut |
100_QV_BCA_Test | ABC,BCA,BCC | BCA |
101_QS_BCC_Test2 | ABC,BCA,BCC | BCC |
102_QSD_CCC_Test3 | ABC,BCA,BCC | - |
Thanks in Advance
Service Provider(Qliksense) initiated Authentication Process
The following process is about how to setup SAML authentication for users in AWS environment if there is no no trust available between enterprise active directory(Idp) and AWS MAD(managed active directory).
for SAML:
Requirements for SAML setup:
Steps for SAML Config:
Note-
If using ALB in AWS then all traffic from Idp will be forwarded to ALB first and then ALB will forward the traffic to the target EC2s. If the ALB's listening port is different to Qliksense proxy's listening port, then update the ACS URL endpoint in Idp with the port that ALB is listening. Please don't use the same port as Qliksense proxy is listening which was available in SP metadata. Example-
Incase of using ALB-ACS URL=https://<saml host uri name>:<ALB listening port>/<virtual proxy prefix>/samlauthn/
Incase of only using EC2/windows host=ACS URL=https://<saml host uri name>:<Qliksense proxy listening port(i.e. default value is 443)>/<virtual proxy prefix>/samlauthn/
Hi,
I have a scenario where I need to filter the data using multiple filters. The filters may be the same dimension loaded multiple times (or if you have any other solution let me know), the scenario is like this:
So if I select "Bridges" in the first search Term "Wood" in the second and "Two way" in the third so it should show me All Bridges that are made of wood and are two way (AND Logic)
If I select "Bridges" in the first term "Wood" and "Concrete" in the second and "One Way" in the third so it should me All bridges that are either made of wood OR concreted and are two way ..
How can I achieve this? The filters in my scenario are coming from the same dimension so I loaded it differently three times.
Any help is appreciated.
Regards.
IF( ISNULL([HLS_RISK_KDCs].[BUSINESS L2], 'NULL') = 'Wealth and Personal Banking' AND ISNULL([HLS_RISK_KDCs].[BUSINESS L3], 'NULL') <> 'Global Private Banking and Wealth' AND (ISNULL([HLS_RISK_KDCs].[Legal Entity L3], 'NULL') <> 'PT Bank Ekonomi Raharja' AND ISNULL([HLS_RISK_KDCs].[Legal Entity L3], 'NULL') <> 'HSBC Finance Corporation' AND ISNULL([HLS_RISK_KDCs].[Legal Entity L2], 'NULL') <> 'HFC Bank Limited'), IF( ISNULL([HLS_RISK_KDCs].[BUSINESS L3], 'NULL') IN ('Asset Management', 'Group Insurance'), [HLS_RISK_KDCs].[BUSINESS L3], IF( ISNULL([HLS_RISK_KDCs].[Location L2], 'NULL') = 'HSBC UK', 'UK RFB', ISNULL([HLS_RISK_KDCs].[Location L2], 'Global') ) ), IF( ISNULL([HLS_RISK_KDCs].[BUSINESS L3], 'NULL') = 'Global Private Banking and Wealth', 'Private Banking', 'NA' ) ) AS [Modified Location L2 - RBWM]
Hi,
I encounter a problem with app export to TEMP folder with REST API.
Using https://domain.qlikcloud.com/api/v1/apps/38ea15de-e461-4869-bf7c-03e63888649d/export endpoint to export the app and then download it. The response should retrieve the location URL for temporary file. But sometimes it returns error - there is no space to export.
Number 5 should return the URL for the temp file.
Can Qlik Cloud trial access SQL Server running on local laptop? I couldn't find easy to follow documentation about it. Getting the error
ERROR [08001] [Qlik][SqlServer] Failed to locate Server/Instance Specified.
Can somebody pl point me what could be the error or steps to follow? Thanks in advance.
In my database, I have a SQL table containing varchar Employee IDs that Qlik is attempting to convert to dates and I don't know why. For example:
EmployeeID | Qlik is auto-converting to: |
710-02-027 | 710-02-027 as a date/dual value |
710-02-028 | 710-02-028 as a date/dual value |
710-02-029 | 710-03-001 as a "corrected" date/dual value |
710-02-030 | 710-03-002 as a "corrected" date/dual value |
710-02-031 | 710-03-003 as a "corrected" date/dual value |
710-02-032 | 710-02-032 as a string value |
710-02-033 | 710-02-033 as a string value |
710-02-034 | 710-02-034 as a string value |
As you can imagine, this is causing havoc to my data model.
Within my app...
the DateFormat setting is: SET DateFormat='M/D/YYYY';
the load script simply queries this field using: Select EmployeeID as "Employee ID";
I've tried casting EmployeeID as varchar in the above script and it doesn't make an difference.
Can someone please tell me how to stop Qlik from auto-converting these values into dates and only load them as the strings they are stored as?
Thank you very much.
Steve
Gostaria de saber se existe a possibilidade de verificar logs de acessos dos aplicativos, ou seja, o login que acessou tal aplicativo, os dias se possível, ou nome da máquina, algum tipo de informação para identificarmos os acessos aos aplicativos disponíveis.
Talvez também quais usuários estão com os aplicativos abertos.
Obrigado.
Hi, I upgrade the Qlik Sense with latest software. After successfully installed, we download and exporting the maps the background map is missing but the points alone able to see in ppt. Kindly suggest.
Estou fazendo uma tabela que contém números de pedidos retirados da base de dados da empresa. Porém ao extrair os dados para o qlik ele adicionou muitos zeros na frente dos números, o que acaba prejudicando a visualização para os usuários pois eles não conseguem digitar o número do pedido da mesma forma que está no banco da empresa, pois está lotado de zeros a frente
Como faço para retirar esses Zeros?
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!
If you want to know what's new across all of the products in our growing Qlik product portfolio.
Get the latest Support information about end-of-product support, new service releases, and general support topics.
Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.
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.
Subscribe to our Events and Webinar page so you do not miss an event
opportunity!
Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.
There is more than one way to find upcoming events, look on the right side
of any Qlik Community forum!
Subscribe to our Events and Webinar page so you do not miss an event
opportunity!
Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.
There is more than one way to find upcoming events, look on the right side
of any Qlik Community forum!