Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 212,869 members
  • 5,973 online
  • 1,987,428 posts
  • 148,822 Solutions
Announcements
Discover what’s possible with embedded analytics! March 6, 10 AM ET SIGN UP!

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    accumulate daily

    Hello,  i have a diagramm (Screenshot). i have a diagram with the following formula. this formula cumulates all values that are in the filtered select... Show More

    Hello, 

    i have a diagramm (Screenshot).

    i have a diagram with the following formula. this formula cumulates all values that are in the filtered selection. i would like to set the counter to 0 every day (midnight) and display the cumulated values for each day (current+past).

    RangeSum(Above(Sum(Erzeugung), 0, date(left([Timestamp_stündlich],10))))

    --> date(left([Timestamp_stündlich],10) is the date

    Please help! Thanks Oliver

    OS92_0-1709628077021.png

     

    Show Less
  • forum

    Deployment & Management

    get permission issue when run command line Repository.exe -bootstrap

    I got a strange issue. I'm doing the Qlik Sense migration which is move current Qlik Sense (1 central + 1 rim) to a new environment. 1. Install Qlik S... Show More

    I got a strange issue.

    I'm doing the Qlik Sense migration which is move current Qlik Sense (1 central + 1 rim) to a new environment.

    1. Install Qlik Sense in new environment

    2.backup all related data from old environment 

    3.restore Postgres SQL db

    4 restore Qlik Shared folder.

    5. imported the old 3 certificates(client, server and root) of Qlik into new server.

    6. run command line "Respository.exe -bootstrap -iscentral -restorehostname"

    but nothing come out in commandline window, I checked the event log and found below error as in attachment.

      Screenshot 2024-03-04 171840.jpgScreenshot 2024-03-04 171932.jpg

    It showing it's about permission issue, but I run the command line with local administrator.

     

    Show Less
  • forum

    New to Qlik Sense

    After update to February 2024, extensions no longer work

    Hello everyone, after update to February 2024, extensions no longer work. In two update attempts, other extensions were always affected. Why is that? ... Show More

    Hello everyone, after update to February 2024, extensions no longer work. In two update attempts, other extensions were always affected. Why is that? Best regards, M. Reinders

    Show Less
  • forum

    App Development

    Adding rows based on cell value

    Hi folks, I have this table:   and i need to get an extra row above each header cell:   LOAD * INLINE [dim1, dim2, dim31, 0x3B1B, header2, n/a, para... Show More

    Hi folks,

    I have this table:

    Frank_Hartmann_0-1709638486922.png

     

    and i need to get an extra row above each header cell:

    Frank_Hartmann_1-1709638571503.png

     

    LOAD * INLINE [
    dim1, dim2, dim3
    1, 0x3B1B, header
    2, n/a, parameter
    3, n/a, value
    4, n/a, parameter
    5, n/a, value
    6, 0x3B1F, header
    7, n/a, parameter
    8, n/a, value
    9, 0x21DE, header
    10, n/a, parameter
    11, n/a, value
    ];

     

    Any ideas how to achieve that?

    Show Less
  • forum

    New to Qlik Sense

    Unable to export Excel from Table while using Microsoft edge

    Unable to export Excel from Table while using Microsoft edge,this below option I am unable to see  
  • forum

    New to Qlik Sense

    Format Numbers

    Guys, how do I make qlik only round when the value is above 0.60, for example 89.60 = 90% and 89.50 = 89%?
  • forum

    New to Qlik Sense

    Need to connect Qlik Sense with JIRA

    I tried to pull the JIRA data into Qlik Sense. When I create a new connection, facing issue.  From Qlik Sense Hub --> Data Load Editor --> Create New ... Show More

    I tried to pull the JIRA data into Qlik Sense. When I create a new connection, facing issue. 

    From Qlik Sense Hub --> Data Load Editor --> Create New Connection --> Click on JIRA --> I gave the JIRA base URL and our user name and password. 

    Then facing error "Failed on attempt 1 to GET (Unable to connect to the remote server)

    Kindly suggest anything I need to do prerequisites. 

    Show Less
  • forum

    Integration, Extension & APIs

    Connect Qlik to Azure Storage through connector

    I wanted the cost management data into Qlik sense , so I put a scheduled export task on the cost mgmt data to a storage account and gave it necessary ... Show More

    I wanted the cost management data into Qlik sense , so I put a scheduled export task on the cost mgmt data to a storage account and gave it necessary access permissions 
    Now, I wanted to pull the data from storage account into Qlik sense enterprise on windows (Feb 2023) using Qlik web connector(Azure Storage) 
    But I'm getting error that "ENCRYPTION_KEY_MISSING - you must manually set an encryption key before creating new connections."

    Can i set the encryption key using Openssl , I downloaded Openssl through this https://slproweb.com/products/Win32OpenSSL.html is it safe to install from this or any other site is there? Will setting encryption key solve my issue?

    Show Less
  • forum

    Qlik Application Automation

    How to Use VB macros to send Email through Outlook in QlikView

    Hi all, Please, can anyone explain or send me a link that explain step by step on how to us VB Script Macros to Send email through Outlook In QlikView... Show More

    Hi all,

    Please, can anyone explain or send me a link that explain step by step on how to us VB Script Macros to Send email through Outlook In QlikView?

    Thanks 

    Show Less
  • forum

    Design and Development

    TDBSP

    Hello , I have a Talend job on TAC that uses the tDBSP component to execute a stored procedure on MariaDB. Despite the stored procedure execution fin... Show More

    Hello ,

    I have a Talend job on TAC that uses the tDBSP component to execute a stored procedure on MariaDB. Despite the stored procedure execution finishing, the tDBSP component does not stop, and the job remains running indefinitely.

     

    Talend Version 8

    tDBSP_1 (conn=285651) Socket error
    java.sql.SQLNonTransientConnectionException: (conn=285651) Socket error

    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!