Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 215,321 members
  • 5,648 online
  • 1,991,652 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

    Do we have a staging installation with Qlik Enterprise

    Hi! Simple question, we operate a production server and wanted to know if we can have a staging license. This will assist us to test some changes like... Show More

    Hi!

    Simple question, we operate a production server and wanted to know if we can have a staging license. This will assist us to test some changes like moving to another domain and changing the admin user.

     

    Thanks

    Show Less
  • forum

    New to Qlik Analytics

    Employee tenure gantt like chart with department transfers

    Hello,I'm currently trying to create Employee tenure gantt like chart, and in order to do that, I am using the fact table of HR charges which unlike t... Show More

    Hello,

    I'm currently trying to create Employee tenure gantt like chart, and in order to do that, I am using the fact table of HR charges which unlike the dimension table of employee table, has sometimes multiple rows for a single employee if that person changed departments throughout his tenure in the company.  With the help of Qlik Community, I've managed to progress as far as putting together gantt chart for employees who did not get department transfers by using the measure expression below:

    Newbie7_0-1623564930656.png

    However, for the employees who have transferred departments and thus have multiple rows of data in HR change fact table, I am not able to get the gantt chart like visualization for the tenure measure.  I'd greatly appreciate it if anyone can let me know how I can get the visualization working for employees who have changed departments and thus have multiple rows of data in the HR change fact table.  

    Newbie7_1-1623565281638.png

    Thank you very much for your help!

     

     

    Show Less
  • forum

    New to Qlik Analytics

    Qlik Sense Server Error (Refused To connect)

    Whenever my laptop updates , Qlik Sense gives the following error :- Refused to Connect.How to solve the Problem? Kindly give the steps in detailed ma... Show More

    Whenever my laptop updates , Qlik Sense gives the following error :- Refused to Connect.
    How to solve the Problem?

    Kindly give the steps in detailed manner

    Show Less
  • 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

    Integration, Extension & APIs

    Qlik CLI filtering for automations by ownerId attribute

    Hi all, fighting with listing all automation for given owner and I could not find any proper documentation how to use --filter option for automations.... Show More

    Hi all,

    fighting with listing all automation for given owner and I could not find any proper documentation how to use --filter option for automations. Only Qlik CLI help within powershell which is not enough.

    Filtering through these attributes should be possible: name, runMode, lastRunStatus, ownerId

    qlik automation ls --filter 'ownerId eq 64ec602e1fa6aadd5ef3b73e' 

    This works for me without an error, but if I check ownerId in output of that command can see different ownerId compared to I used within command above. For some users works well for some does not.

    Anyone here has some experience pls?

    Thank you!

    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

    Graphique combiné composé de graphiques en aires et en lignes (Qlik Sense)

    Bonjour On me demande de créer un graphique combiné avec des aires et des lignes. Dans Qlik Sense je n'ai trouvé que la composition barres et lignes. ... Show More

    Bonjour

    On me demande de créer un graphique combiné avec des aires et des lignes.

    Dans Qlik Sense je n'ai trouvé que la composition barres et lignes.

    D'avance merci de votre aide

    garph_combiné.JPG

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