Skip to main content

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 160,340 members
  • 9,567 online
  • 1,768,703 posts
  • 134,807 Solutions
Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.

Welcome to Qlik Community

FOR NEW MEMBERS

Everything you need to make your Qlik Community experience valuable.

SEARCH KNOWLEDGE BASE

Explore official Support and member created content.

WHAT'S NEXT IS NOW

Seven Data Integration and Quality Scenarios for Qlik and Talend Solutions.

Analytics

Forums for Qlik Analytic solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

Data Integration

Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources

Qlik Gallery

Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.

Support

Chat with us, search Knowledge, open a Case, read the latest Updates Blog, find Release Notes, and learn about our Programs.

Events

Learn about upcoming Qlik related events, webinars and local meetups.

Groups

Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.

About Qlik Community

Get started on Qlik Community, find How-To documents, and join general non-product related discussions.

Blogs

Hear directly from Qlik employees in our ten unique blogs.

Qlik Resources

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

Qlik Academic Program

Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

Community Sitemap

Here you will find a list of all the Qlik Community forums.

Recent Discussions

  • forum

    App Development

    Find the string between two fields

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

    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

    Show Less
  • forum

    New to Qlik Sense

    SAML Authentication with AWS ALB and Qliksense EC2 Instance

    Service Provider(Qliksense) initiated Authentication Process The following process is about how to setup SAML authentication for users in AWS environm... Show More

    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:

    • Idp=Identity Provider=Enterprise active directory
    • Service Provider=Qliksense=Hosted in EC2 instance

    Requirements for SAML setup:

    • Identity Provider metadata from enterprise active directory 
    • Service provider metadata exported from virtual proxy of qliksense
    • SSL certificate in .pfx format

    Steps for SAML Config:

    1. First get the Idp metadata in XML format
    2. Stop all the Qliksense services
    3. Install the SSL certificate in .pfx format in personal>certificates in mmc
      1. CSP value of the SSL certificate should be Microsoft Enhanced RSA and AES Cryptographic Provider for SHA-256
      2. Change the value of CSP using openssl if CSP value is different. No issues or risk in doing that.
    4. Update the thumbprint of the certificate in Proxy>Security
    5. Create a new virtual proxy in QMC by following steps mentioned by Qlik
    6. Name of the proxy and prefix could anything as it is only used for identification from default proxy
    7. Header of the cookie session again could be anything. example you can add the prefix here as a suffix such as -prefix.
    8. SAML host URI is the name that you would like users to use while accessing the qliksense over url. It is not mandatory to be same as the actual EC2 DNS/host/FQDN name. Lets say if you are using ALB then you may put the friendly DNS/CNAME name of ALB.
    9. Entity ID could be any random user defined value
    10. Upload the Idp metadata
    11. User Attribute would be the identity claim name in SAML response that you would like to use such as Employee ID, Employee Email etc. Please check with the Idp on what identity claims they could provide in SAML response.
    12. User Directory again could be the identity claim field name that holds Domain/Employee ID. Here field name should be mentioned without square brackets[]. If [] brackets are used then whatever value mentioned inside the [] will become a static value for all users.
    13. Link to central node or the node you want in the SAML Virtual Proxy>Load balancing
    14. Add the SAML Host URI name to the whitelist host list of SAML Virtual Proxy>Advanced
    15. Encryption to be SHA-256
    16. Add the SAML attributes mapping per the fields available in SAML response. SAML field name should be same as the attribute name in SAML resposne and Qliksense field name could be as you like.
    17. Click on Apply
    18. Link the proxy through SAML Virtual Proxy>Proxies
    19. Download the service provider metadata by Virtual Proxy>SAML Virtual Proxy
    20. Upload the SP metadata to Idp if possible
      1. Otherwise manually open the SP metadata
      2. Copy the entity id and put the same value in identifier field in Idp
      3. Copy the ACS(AssertionConsumerService) URL value and put it in the Assertion endpoints fields in Idp
      4. NAME ID claim should be transient in Idp
      5. Copy the x509 certificate value and upload in Idp
      6. Configure the identity claims, role claims etc. in Idp based on the information of an user you need in SAML response
      7. Signature encryption to SHA-256

    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/

    Show Less
  • forum

    New to Qlik Sense

    Multiple filters with AND and OR Logic

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

    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:

    mansoorsheraz_0-1685219576261.png

     

    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.

    Show Less
  • forum

    New to Qlik Sense

    script

    @Ram9392  IF( ISNULL([HLS_RISK_KDCs].[BUSINESS L2], 'NULL') = 'Wealth and Personal Banking' AND ISNULL([HLS_RISK_KDCs].[BUSINESS L3], 'NULL') <> 'Glob... Show More

    @Ram9392 

    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]

    Show Less
  • forum

    Integration, Extension & APIs

    App export TEMP folder

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

    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.

    Michael_CreoLabs_0-1685213021018.png


    Number 5 should return the URL for the temp file.

    Show Less
  • forum

    Connectivity & Data Prep

    Qlik Cloud to SQL Server connectivity

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

    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.

    Show Less
  • forum

    App Development

    How to prevent conversion of string to date

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

    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

     

    Show Less
  • forum

    Brasil

    Log de acessos QlikSense - SaaS

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

    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.

     

     

    Show Less
  • forum

    New to Qlik Sense

    Color Issue while exporting maps

    Hi, I upgrade the Qlik Sense with latest software. After successfully installed, we download and exporting the maps the background map is missing but ... Show More

    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. 

    Show Less
  • forum

    Brasil

    Qlik Sense adicionou zeros ao campo

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

    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

    Capturar.PNG

    Como  faço para retirar esses Zeros?

    Show Less

Blogs

Community News

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

Blogs

Qlik Academic Program Blog

Read the latest blog around the Qlik Academic Program.

Blogs

Qlik Product Innovation Blog

If you want to know what's new across all of the products in our growing Qlik product portfolio.

Blogs

Support Updates Blog

Get the latest Support information about end-of-product support, new service releases, and general support topics.

Blogs

Qlik Design Blog

Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.

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

Events and Webinars

Qlik and Qlik Community Hosted Events

Subscribe to our Events and Webinar page so you do not miss an event opportunity!

choose and register

Event

Welcome to Qlik

Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

On-Demand

Events

Upcoming Events and Webinars

There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

Upcoming

Events and Webinars

Qlik and Qlik Community Hosted Events

Subscribe to our Events and Webinar page so you do not miss an event opportunity!

choose and register

Event

Welcome to Qlik

Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

On-Demand

Events

Upcoming Events and Webinars

There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

Upcoming