Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 215,325 members
  • 5,525 online
  • 1,991,664 posts
  • 149,204 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

    App Development

    Gantt

    Hi guys!Following question because i think i go crazy.I have a table with "reclamations" and this "reclamations" have different Date "Positions"Some a... Show More

    Hi guys!

    Following question because i think i go crazy.

    I have a table with "reclamations" and this "reclamations" have different Date "Positions"

    Some are notificated = we was informed that there is a problem, some are picked up from us from the customer, some are arrived our stock.

    then there are timestamps when the customer is informed about costs and when for him its ok the date when gives us the ok.

    start repair date, delivery etc.

    All i want to have is a gantt with a timleine where i can mke this visible but i dont check it.

    example for a line:

    3 days from notification to pickup, 7 days from pickup to arrive our company, 15 days from inform the customer to his answer, 8 days for repair / production, 4 days from delivery stock to shippment.....

     

    Has anybody an idea how i can solve this problem?

     

    Thank you very much!

    Show Less
  • forum

    App Development

    Matching in Script, based on count()

    Hi everyone, i have a small logic problem matching 2 fields based on their count amount. i have managed to get the required result, using the set anal... Show More

    Hi everyone,

    i have a small logic problem matching 2 fields based on their count amount. i have managed to get the required result, using the set analysis, but this is not working as expected when i want to filter, based on this result field.

    So, consider having the following Table:

    CreditorNr | Type | BankNr

    010001     | 200   | 12345200

    010001     | 200   | 12345200

    010001     | 200   | 12345200

    010001     | 200   | 12345100

    010001     | 100   | 12345100

    Using the following formula, i obtained the following MatchField:

    =aggr(If(
    Count(Distinct Type ) = 1 and
    Count(Distinct BankNr) = 1, 'Partner bank is clear', 'Partner bank is not clear'), CreditorNr , BankNr)

    i get following results, that are also correct:

    CreditorNr | Type | BankNr       | MatchField

    010001     | 200   | 12345200   | Partner bank is clear

    010001     | 200   | 12345200   | Partner bank is clear

    010001     | 200   | 12345200   | Partner bank is clear

    010001     | 200   | 12345100   | Partner bank is not clear

    010001     | 100   | 12345100   | Partner bank is not clear

     

    Anyway, when trying to implement this in the Script, i dont get the correct result. In the Script i use the following code:

    TEMP:
    NoConcatenate
    Load CreditorNr,
    If(Count(Distinct Type) = 1 and
    Count(Distinct BankNr) = 1, 'Partner bank is clear', 'Partner bank is not clear') as ScriptMatch
    Resident BankTab
    Group by CreditorNr, BankNr;

    And i get the following result:

    CreditorNr | Type | BankNr       | MatchField                        | ScriptMatch

    010001     | 200   | 12345200   | Partner bank is clear         | Partner bank is clear

    010001     | 200   | 12345200   | Partner bank is clear         | Partner bank is not clear

    010001     | 200   | 12345200   | Partner bank is clear         | Partner bank is clear

    010001     | 200   | 12345200   | Partner bank is clear         | Partner bank is not clear

    010001     | 200   | 12345200   | Partner bank is clear         | Partner bank is clear

    010001     | 200   | 12345200   | Partner bank is clear         | Partner bank is not clear

    010001     | 200   | 12345100   | Partner bank is not clear   | Partner bank is clear

    010001     | 200   | 12345100   | Partner bank is not clear   | Partner bank is not clear

    010001     | 100   | 12345100   | Partner bank is not clear   | Partner bank is clear

    010001     | 100   | 12345100   | Partner bank is not clear   | Partner bank is not clear

    So it basically goes through every BankNr and duplicates the data, once bank is clear, and once bank is not clear... 

    Can anyone please give me a hint on what im i doing wrong in the script?


    Thank you for the support. 🙂

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

    Qlik Cloud Data Integration

    Embedding App sheet in Salesforce

    hi all trying to embed a sheet from Qlik Saas App into salesforce. added Content Security Policy with the salesforce URL and I'm receiving an error me... Show More

    hi all

    trying to embed a sheet from Qlik Saas App into salesforce.

    added Content Security Policy with the salesforce URL and I'm receiving an error message.

    is anyone familiar with this error?

    advance thanks

    ilanbaruch_0-1711635967473.pngilanbaruch_1-1711636000796.png

     

    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

    load data from PDF File

    hey ! Is it possible to load a PDF file containing text and a data table into a Qlik Sense app and work with the data in the app? If so, how can I do ... Show More

    hey !

    Is it possible to load a PDF file containing text and a data table into a Qlik Sense app and work with the data in the app? If so, how can I do it?

    Additional details:

    I want to be able to load the PDF file each time I use the app.
    The PDF file contains both text and a data table.
    I want to be able to work with the data in the app, such as creating visualizations and performing calculations.

    Please provide any relevant documentation or tutorials that I can use to learn more about this process.

    Thank you in advance for your help!

    Show Less
  • forum

    New to Qlik Analytics

    Creation of New Columns depending on the value of a column

    Hello, Currently i have a table as such: Type Type ID Medical 123 Medical 126 Vehicle ABC Medical 127   What i would like.... Type Me... Show More

    Hello,

    Currently i have a table as such:

    Type Type ID
    Medical 123
    Medical 126
    Vehicle ABC
    Medical 127

     

    What i would like....

    Type Med ID Vehicle ID
    Medical 123  
    Medical 126  
    Vehicle   ABC
    Medical 127  

     

    how does one do this?

    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

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