Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 215,261 members
  • 4,662 online
  • 1,991,530 posts
  • 149,195 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

    Catalog and Lineage

    Anyone used Qlik sense?

    My new role requires using Qlik sense, does anyone have any experience with it? I had used PowerBI and Tableau before, would that help?
  • forum

    App Development

    Use a Formula loaded from database

    Hi veryone, is it possible to use a formula in a pivot table which was loaded from database? I've loaded a table from our database which looks like th... Show More

    Hi veryone,

    is it possible to use a formula in a pivot table which was loaded from database?

    I've loaded a table from our database which looks like that

    markuskoessler_0-1711549102436.png

    those formulas work if I use them directly in my pivot table, but not if use the field which stores the formulas,

    I'm ending with something like that

    markuskoessler_1-1711549214995.png

    Within the pivot table I've several If-Statements like 

    if(SPALTEBVBEZEICHNUNG='Vorjahr',
    if(SPALTEBVID=1,KENNZAHL_KONTAKTE_VJ,

    ...

    where KENNZAHL_KONTAKTE_VJ is one of my fields storing a formula.

    I've tried to write it like '$(=KENNZAHL_KONTAKTE_VJ)' or =$(=KENNZAHL_KONTAKTE_VJ) but i just don't get it.

    Maybe someone has a hint for me?

    Thanks!

    Markus

     

     

    Show Less
  • forum

    New to Qlik Analytics

    How to implement Qliksense - Text Analysis

    Hi Friends, I got a requirement that is Categories the types of Incidents from ServiceNow data. Our source data from ServiceNow, every day we will loa... Show More

    Hi Friends,

    I got a requirement that is Categories the types of Incidents from ServiceNow data.

    Our source data from ServiceNow, every day we will load data from ServiceNow to Qlik sense. Actually the data flow is ServiceNow >> Gsheet >> Qliksense.

    Actually the requirement is in the below:

    Please find the below sample incident data which was raised by users with different short descriptions.

    Incident_number Short Description Created By Open Date Due Date State
    INC001 Unable to access XYZ stream, please provide access ABC 3/27/2024 4/1/2024 Open
    INC002 Got error message like 'Access Denied' while accessing the ABC dashboard URL link CDE 3/26/2024 4/1/2024 Open
    INC003 I am unable to access the folder FGH 3/25/2024 4/1/2024 Open
    INC004 I am unable to sign in Workday portal IJK 3/24/2024 4/1/2024 Open
    INC005 Can you grand me access to the database LMN 3/23/2024 4/1/2024 Open
    INC006 Batch job failed to run OPQ 3/22/2024 4/1/2024 Open
    INC007 XYZ Dashboard qmc task aborted RST 3/21/2024 4/1/2024 Open
    INC008 Failed - Informatica xyz_inflow task incomplete UVW 3/20/2024 4/1/2024 Open

     

    Here row number from 1 to 5 should fall under "Access Related Issue" category and row number from 6 to 8 should fall under "Batch Job Related Issue".

    Category Count of Incidents
    Access Related Issue 5
    Batch Job Related Issue 3

     

    How can we achieve this. Can you please help me this.

    Appreciate your help and thanks in advance.

     

    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

    New to Qlik Analytics

    Counting of non negative Values

    Hi Team, Please refer below details i need the help to count only positive value excluding 0. in total i need to need count of if can anybody help me ... Show More

    Hi Team,

    Please refer below details i need the help to count only positive value excluding 0. in total i need to need count of if can anybody help me on this.

     

     

    Distributor Name Sub Dealer Name YTD-2024 label_1
    A AA 1 1
    B AA -1 0
    C Bc 2 2
    D BD -1 1
    E SD -1 1
    F FE -1 1
    Total   -1 6
    Show Less
  • forum

    Integration, Extension & APIs

    Embedding QlikSense dashboard in iframe

    Hi, I am using a Qlik Sense dashboard (it is currently being hosed in cloud) with JWT authentication and Section Access.  I am able to open up the das... Show More

    Hi,

    I am using a Qlik Sense dashboard (it is currently being hosed in cloud) with JWT authentication and Section Access. 

    I am able to open up the dashboard from my web application as a separate page, but I'd like to open it up in an iframe. 

    Has anyone implemented this?

    Thanks.

    Show Less
  • forum

    New to Qlik Analytics

    Dimensional reference line not functioning with fractile calculation

    Hi, I am creating a chart with multiple lines to indicate a base price, a price that gets 50% of the calls and a line indicating a price that gets 100... Show More

    Hi, I am creating a chart with multiple lines to indicate a base price, a price that gets 50% of the calls and a line indicating a price that gets 100% of calls. 


    The 3 boxes to the right indicate where the lines should be. The red line and the green line are functioning correctly but the yellow line should be at 35 and is instead fixed at 0. 


    To calculate the yellow line I am using this calculation:  
    round(fractile(total_revenue, 0.5)*1.2 , 5)


    The reason I think there might be an issue here is because the green line uses almost the same calculation, but shows the correct answer. 


    round(fractile(total_revenue, 1.0)*1.2 , 5)


    Below are screenshots of how the lines are showing up on the bar chart. The green line and red line are correct the but the yellow line is not at the 35 mark even though for the box and the yellow line I have just put the same calculation. I have tried adjusting the fractile value for the calculation and there still mismatch for the yellow line. I also tried deleting and recreating the master item with the calculation, deleting and recreating the line, deleting and recreating the box and just adding the calculation to the box and the chart without the master item. 


    Does anyone have any idea what could be wrong here? 

     

    linee1.png

      

    linee2.png

    Show Less
  • forum

    Qlik Cloud Data Integration

    Can't install Qlik Sense Entensions on Qlik Cloud

    The extensions used in qlik sense on premise can't install on Qlik Cloud. It shows a message like "Invalid File". The extension is this:   Can anyone... Show More

    The extensions used in qlik sense on premise can't install on Qlik Cloud. It shows a message like "Invalid File". The extension is this:

    ironwill_1-1711571885079.png

     

    Can anyone help me please?

    Regards,

    Show Less
  • forum

    QlikView App Dev

    Force 0 on Continuous line chart when expression is Avg( )

    Hi all, I have a line chart over a continuous x-axis that I want to drop to zero when no data exists for that time value.If my query is a SUM, then th... Show More

    Hi all,

    I have a line chart over a continuous x-axis that I want to drop to zero when no data exists for that time value.

    If my query is a SUM, then this is fine by using  + SUM({1}0) 

    My problem is that for this chart I am using an AVG function.

    I've tried +AVG({1}0) but this didn't work. 

    Has anyone found a solution to this problem before?

     

    Show Less
  • forum

    Move to Cloud

    HL7 performance testing with jmeter

    I'm new to JMeter and trying to send HL7 messages to test performance of application. Unfortunately i didn't find much information over the internet.M... Show More

    I'm new to JMeter and trying to send HL7 messages to test performance of application. Unfortunately i didn't find much information over the internet.
    My first query is — is JMeter support HL7 messages to be send. If yes then do I need any plugin for it?
    I am using TCP sampler for sending messages, is this a correct way?

    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!