Skip to main content

Welcome to
Qlik Community!

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

    New to Qlik Analytics

    Combining if into set analysis

    Hi all, below is a snapshot of my data which starts in Jan 1st 2023.  I wish find total using set analysis with the following criteria: 1. If(Actual >... Show More

    Hi all, below is a snapshot of my data which starts in Jan 1st 2023.  I wish find total using set analysis with the following criteria:

    1. If(Actual > Planned, Actual, Planned) and

    2. Between Monday and Friday.  Therefore, the correct total planned would be 11.

    I don't wish to create a new variable or using the load editor.

     

    Jobid Date Day Planned Widgets Actual Widgets if Actual > Planned,Actual,Planned
    1 18-Mar-24 Mon 0 1 1
    2 19-Mar-24 Tue 2 2 2
    3 20-Mar-24 Wed 2 1 2
    4 21-Mar-24 Thu 1 1 1
    5 21-Mar-24 Thu 0 1 1
    6 22-Mar-24 Fri 2 2 2
    7 22-Mar-24 Fri 2 2 2
    8 23-Mar-24 Sat 2 2 2
    9 24-Mar-24 Sun 2 2 2
          13 14 15
               
        Mon to Fri 9 10 11

     

     

    Show Less
  • forum

    Connectivity & Data Prep

    Error noFileSize for QVD from a SFTP connector

    Loading a QVD file from a SFTP connector (not from webconnector) occurs an error: noFileSize Any file format doesn't have an error when loading.I tri... Show More

    Loading a QVD file from a SFTP connector (not from webconnector) occurs an error: noFileSize

    t_donnet_0-1711638845891.png

    Any file format doesn't have an error when loading.
    I tried to load with an other QVD, the same issue persist.

    Antivirus doesn't scan the SFTP folder.
    There is not file access restrictions, antivirus software locking the file, or resource bottlenecks

    Any idea to fix it?

     

     

    Show Less
  • forum

    Deployment & Management

    Disable/Hide "Create App" button via rule for specific user role

    How we can Disable/Hide "Create App","Monitoring Apps" and  "Everyone" button via rule for specific user role.
  • forum

    Component Development

    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 : jd... 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

    Column constraint change is not replicated (Oracle to MSSQL)

    The replication task is working, we change a column from NOT NULL -> NULL and the task gets suspended. The task's DDL Handling policy says: "When sour... Show More

    The replication task is working, we change a column from NOT NULL -> NULL and the task gets suspended.

    The task's DDL Handling policy says: "When source table is altered: ALTER target table"

    At the moment, the tool is version 2022.11.0.208, we will upgrade it next week

    Qlik Replicate 

    Show Less
  • forum

    New to Qlik Analytics

    Bucketing Sales activity per month

    Hi there, I'm looking for a way to show sales activity done in the first month.  Currently this is only possible for the Current month as there is nex... Show More

    Hi there,

    I'm looking for a way to show sales activity done in the first month. 

    Currently this is only possible for the Current month as there is next month activity.

    How do I call on a specific activity date in a bucket?

    The metrics I (think) need to use are:

    [Revenue]

    [start date](in days eg. 01/01/2024, 02/01/2024, etc)

     

    So I want the following:

    Jan 2023 showing Month 1 revenue

    Feb 2023 showing Month 1 revenue

    March 2023 showing Month 1 revenue

    etc. etc.

    Is there a way to do this?

    Thanks

    Robert

    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

    New to Qlik Analytics

    Dividing accumulating expressions

    Hi, I am trying to do the Num and den and accumulative, like Num = 400 and Den = 455 for 2022 Jan , its percentage is 87.9 and it is accumulating feb ... Show More

    Hi, I am trying to do the Num and den and accumulative, like Num = 400 and Den = 455 for 2022 Jan , its percentage is 87.9 and it is accumulating feb 88.9 and it is accumulating to  176% intead of feb 88.9 and march 89

    This is my expression.

    =rangesum(above(Count({<[NUMERATOR]={'1'},[QUESTION]={'Q9'}>} distinct [RESPONSEID]),0,RowNo(total)))/rangesum(above(Count({<[DENOMINATOR]={'1'},[QUESTION]={'Q9'}>} distinct [RESPONSEID]),0,RowNo(total)))

    Show Less
  • forum

    Deployment & Management

    NPRINTING VS QLIKSENSE STORY TELLING??

    Hello everyone,  I am failing to understand what advantages could bring for me to implement NPrinting.  What is the difference in capabilities between... Show More

    Hello everyone, 

    I am failing to understand what advantages could bring for me to implement NPrinting. 

    What is the difference in capabilities between NPrinting and QlikSense Story telling?

     

    thanks in advance

    Show Less
  • forum

    App Development

    $() Expansion is ignoring the dimension filters in a chart table

    Hello Qlik lovers, I have an interesting case that I came across and I hope you can help me solve it. For this case, I am trying to filter against a n... Show More

    Hello Qlik lovers, I have an interesting case that I came across and I hope you can help me solve it.

    For this case, I am trying to filter against a numeric field [KPI_Code]

    I created a Table and inserted [KPI_Code] as a Dimension.

    I have 2 expressions, the results are in the table below

    Expression A: Max(KPI_Code)

    Expression B: Aggr(Only({<KPI_Code={"$(=Max(KPI_Code))"}>}KPI_Code),KPI_Code)

    when I use a dollar sign expansion, it always gives me the maximum number in the dataset, disregarding the dimension value.

    How can I use $() and still get values just like in Expression A ???

    ------------

    Note: I need to use the $() because I need the output value inside a variable to call its expression

    Example: vKPI_$()_Expression

    if the $() resulted in 1001 then the variable would become  vKPI_1001_Expression and I would use it's saved expression output in the cell beside its corresponding KPI_Code

     

    KPI_Code Expression A Expression B
      1004 1004
    1001 1001 -
    1002 1002 -
    1003 1003 -
    1004 1004 1004
    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!