Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 215,316 members
  • 5,765 online
  • 1,991,646 posts
  • 149,201 Solutions
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    Deployment & Management

    'HSTS missing from HTTP' vulnerability (RFC 6797)

    hi, to be HSTS compliance, I followed the steps in article below. https://community.qlik.com/t5/Official-Support-Articles/HTTP-Strict-Transport-Securi... Show More

    hi, to be HSTS compliance, I followed the steps in article below.

    https://community.qlik.com/t5/Official-Support-Articles/HTTP-Strict-Transport-Security-HSTS-in-Qlik-Sense/ta-p/1711505

    this is working fine for port 443. but we are using other ports as well and HSTS is not compliance to those ports. 

    How to make QS compliance to HSTS to all ports (at least port we use).

    Can we mention ports in our header settings or in any other config files?

    Strict-Transport-Security: max-age=31536000; includeSubDomains

     

    And there is another article to Redirect HTTP to HTTPS in Qlik Sense on port 80. but I need for other ports as well. https://community.qlik.com/t5/Official-Support-Articles/How-to-Redirect-HTTP-to-HTTPS-in-Qlik-Sense/tac-p/2433345#M13568

     

    Appreciate your reply and any inputs. 

    Thank you.

     

    found some related article to understand issue:

    https://www.tenable.com/plugins/nessus/142960

    https://datatracker.ietf.org/doc/html/rfc6797

    Show Less
  • forum

    Move to SaaS

    Qlik Cloud & Career Growth: Navigating New Horizons in Atlanta & Dallas 2024

    Hello Qlik Friends! We’re thrilled to announce our first Qlik Meetup of 2024, a fantastic opportunity to reunite with our vibrant Qlik community! Whet... Show More

    Hello Qlik Friends!

    We’re thrilled to announce our first Qlik Meetup of 2024, a fantastic opportunity to reunite with our vibrant Qlik community!

    Whether you’re a Qlik newbie or a seasoned pro, this event is the perfect place to engage, learn, and share in all things Qlik.

    Let’s dive into a year of growth, inspiration, and amazing connections together.

    At the moment, we are hosting two in-person events, more details can be found at the end of this message:

    Apr-11th: Atlanta, GA
    Apr-25th: Dallas, TX

    Attention! Spaces are limited to 35 attendees , so make sure to secure your spot early and join us for insightful conversations and networking.

    We can’t wait to see familiar faces and welcome new ones into our circle!

    Here’s what we have lined up for you:

    Agenda

    6:00 - 6:30 PM: Warm Welcome & Networking
    Kick off the evening with some light bites, refreshments, and announcements. A great chance to mingle!

    6:30 - 7:00 PM: Embracing Qlik Cloud – Why Make the Move?
    Dive into the advantages and considerations of transitioning to Qlik Cloud, including cost insights.

    7:00 - 7:30 PM: Navigating the Cloud Migration
    Learn the ins and outs of moving your Qlik applications to the cloud, focusing on data governance and security.

    7:30 - 8:00 PM: Unveiling Qlik Cloud’s Power Features
    A quick tour through Qlik Cloud’s standout features, including Notifications, Alerts, Tabular Reporting, and more.

    8:00 - 8:30 PM: Charting Your Qlik Career Path
    We will guide you through Qlik certification pathways, educational resources, and career tips within the Qlik ecosystem.

    Speakers:

    Alan McLaughlin , IPC Global Principal
    Ana Silva , IPC Global Support Lead
    Igor Alcantara , IPC Global Science and Education Director
    Mark Costa , IPC Global Director of Data and DevOps

     

    Atlanta, GA
    =============
    When & Where:
    Date: April 11th, 2024
    Time: Doors open at 6:00 PM for check-in & networking, sessions to begin at 6:30 PM
    Location: Roam Perimeter Center, 1151 Hammond Drive NE, Atlanta, GA 30346
    How to find us: When at the facility, look for the Theater Conference room.

    Attend: https://www.meetup.com/atlanta-qlik-dev-group/events/299867255/?utm_medium=referral&utm_campaign=share-btn_savedevents_share_modal&utm_source=link

     

    Dallas, TX
    =============
    When & Where:
    Date: April 25th, 2024
    Time: Doors open at 6:00 PM for check-in & networking, sessions to begin at 6:30 PM
    Location: Roam Grandscape, 5752 Grandscape Boulevard Suite 225, The Colony, TX 75056

    Attend: https://www.meetup.com/dallas-qlik-dev-group/events/299867966/?utm_medium=referral&utm_campaign=networkEvent_savedevents_share_modal&utm_source=link

    Would like us to host an event in your city? Contact us for more information.

    Let’s make this an unforgettable kickoff to 2024 with insightful discussions, learning, and networking. See you there!

    Show Less
  • forum

    New to Qlik Analytics

    Script error: Invalid expression

    I have employee data - EmpName, Joining Date, Exit Data and added Flag value status as current, New and exit. Each month there are new and exit employ... Show More

    I have employee data - EmpName, Joining Date, Exit Data and added Flag value status as current, New and exit. Each month there are new and exit employees. The next month current is a calculated value using previous month data.

    I am getting Invalid Expression for the below script. Can someone please help me understand what is missing in the below.

    Load
    count(if(status='Current',"EmpName")) as JanExisting,

    count(if(status='Current',"EmpName"))
    +count(if(status='New' and Month='Jan',"EmpName")) -
    count(if(status='Exit' and Month='Jan',"EmpName"))
    as JanFinal
    Resident MyTable;

    Load
    JanFinal +
    count(if(status='New' and Month='Feb', "EmpName", null())) -
    count(if(status='Exit' and Month='Feb', "EmpName", null()))
    as FebFinal

    Resident MyTable;

    Load
    FebFinal +
    count(if(status='New' and Month='Mar', "EmpName", null())) -
    count(if(status='Exit' and Month='Mar', "EmpName", null()))
    as MarFinal
    Resident MyTable;

    Show Less
  • forum

    Qlik Replicate

    Qlik Replicate Certificate update

    We are trying to update Qlik replicate ssl certificate..In the installations steps we have app id ::{4dc3e181-e14b-4a21-b022-59fc669b0914} is this app... Show More

    We are trying to update Qlik replicate ssl certificate..
    In the installations steps we have app id ::{4dc3e181-e14b-4a21-b022-59fc669b0914} is this appid correct ?? 

    How can i verify this app id is correct on my windows machine before updating the certificates without any issue running the below command 


    netsh http add sslcert ipport=0.0.0.0:443 certhash=<certificate thumbprint> appid={4dc3e181-e14b-4a21-b022-59fc669b0914}

    Show Less
  • forum

    New to Qlik Analytics

    Comment faire un slider qui prend en compte des tranches (plages) de données ?

    Bonjour, Comment faire un slider qui prend en compte des tranches (plages) de données comme sur QlikView ? Y a-t-il une extension autre que celle du ... Show More

    Bonjour,

    Comment faire un slider qui prend en compte des tranches (plages) de données comme sur QlikView ?

    Wal_Riachi_0-1711627489018.png

    Y a-t-il une extension autre que celle du bundle ? Car celle du bundle permet de sélectionner qu'une seule valeur.

    Merci d'avance,

    Waïl

     

    Show Less
  • forum

    Qlik Application Automation

    QAA backup

    Hi all, I am searching for some automated solution how to backup created QAAs, but facing issues like... You can get json definition via API endpoint... Show More

    Hi all,

    I am searching for some automated solution how to backup created QAAs, but facing issues like...

    1. You can get json definition via API endpoint via Qlik CLI, but that json file is not possible be uploaded via Upload Workspace directly in QAA editor. By other words, I cannot upload json file with content of QAA in json format. Automation content would need to be get by Download Workspace option only diretly in QAA editor which cannot be automated...
    2. You can get content of your automations only, not automations owned by someone else. Idea was to back up all the tenant's automation.

    Any ideas here? Anyone was facing the same challenge?

    Show Less
  • forum

    Qlik Application Automation

    How to correct umlauts that have been incorrectly encoded

    I've got some data from an external source where the Umlaut characters have been encoded as an A-like character. It's a real chore to identify the inc... Show More

    I've got some data from an external source where the Umlaut characters have been encoded as an A-like character. It's a real chore to identify the incorrect character in the data then find the correct unlaut, let alone doing the Replace. I cannot be sure I'm even identifying the correct match as it's a matter of deduction by working out what it should be. I'm wondering if there's a way to get Qilk to translate these or failing that a way of looking up individual characters online so I can build an table for a map.

    i.e.

    Character      Replacement

    Ãœ Ü
    Ö Ö
    Ń Ń
    ß ß
    Ó Ó
    ÄŒ Č
    É É
    Ň Ň
    Ř Ř
    Äš Ě
    Åž Ș
    Ž Ž
    Ź Ź
    Show Less
  • forum

    Installing and Upgrading

    Connexion à une base de données HFSQL

        Bonjour, Je rencontre actuellement un problème de connexion à une base de données hfsql Type de base de données : JDBC généralURL : jdbc :... Show More
     
     

    Bonjour,

    Je rencontre actuellement un problème de connexion à une base de données hfsql

    Type de base de données : JDBC général
    URL : jdbc : odbc : nom du serveur 
    Jar Pilote : rt (à partir de jre 7 64 bits)
    Nom de la classe : sun.jdbc.odbc.JdbcOdbcDriver
    Lorsque je vérifie la connexion, j'obtiens ce message d'erreur :

    Aucun pilote approprié trouvé pour jdbc

    J'ai besoin d'aide à ce sujet. Merci d'avance .

    Show Less
  • forum

    Qlik Replicate

    Replicate data from last 24 months

    Hello, My Source connection is an Oracle database. I have audit tables in my Replicate task "Full Load + Apply Changes" the tables are huge and by nat... Show More

    Hello,

    My Source connection is an Oracle database. I have audit tables in my Replicate task "Full Load + Apply Changes"

    the tables are huge and by nature there is heavy DML operations. 

    My target is Snowflake "Extra Small Size", I see significant amount of latency when i tried replicating audit tables. 

    Is there a way I can limit the date range to be at most 24 months of history data in the replicate task ?

     

    Thank you.

    Show Less
  • forum

    Qlik Enterprise Manager

    Reload QEM task using Python API with filters

    Hi,   I am trying to reload a Qlik Replicate task using QEM Python API.  I am using reload_table method to achieve my goal. However, I do not see any ... Show More

    Hi,

     

    I am trying to reload a Qlik Replicate task using QEM Python API. 

    I am using reload_table method to achieve my goal.

    However, I do not see any option to define filters using the above method. 

    I have tried the below:

    reload_table(server, table, filters:{col1:value1,value2})

    but that doesn't work.

    Is there any way to achieve my said requirement using the above method or is there any other method which I can use to reload the task with table filters. 

    Kindly assist. 

    Show Less
Leaderboard

Customer Story

Qlik Data Integration & Qlik Replicate story

Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.

Customer Story

Building a Collaborative Analytics Space

Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.

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!