Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 240,968 members
  • 3,447 online
  • 2,023,725 posts
  • 152,190 Solutions
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    Please help me change default selection colors. Nothing works!

    Why in all of creation does this not work at all!?https://qlik.dev/extend/create-custom-themes/custom-themes-basic-examples/#example---app-selections ... Show More

    Why in all of creation does this not work at all!?
    https://qlik.dev/extend/create-custom-themes/custom-themes-basic-examples/#example---app-selections

    It should not be this hard to set a global default for selected, alternative, excluded etc. The code samples from the above link do nothing. I know I'm testing updated files because I can see title text change. I refuse to edit every single filterpane. 
    From a CSS angle, the selection appears to use the class .RowColumn-S which I can override by winning on specificity but it feels like a hack especially since the docs are clearly stating that I should be able to do this in theme.json.

    Please clear this up for me.

    Show Less
  • forum

    Administering and Monitoring

    Qlik server adm certificate

    Where can i study do the adm certificate? I’m searching everywhere but with no sucess…
  • forum

    New to Qlik Analytics

    Using IF Statement to select a date

    I am trying to create a measure counting the number of working days between a hire date and termination date using the formula below NetWorkDays([hire... Show More

    I am trying to create a measure counting the number of working days between a hire date and termination date using the formula below

    NetWorkDays([hireDate],[terminationDate1])

    This works for employees with a term date but returns blank when the term date is empty. How can I fix this such that if term date is blank, it uses Today as the end date in this formula?

    Show Less
  • forum

    App Development

    Employee Log

    Hello, I built an app that performs the followings:    Each day it loads an excel file that contains a list of active employees  and then saves the fi... Show More

    Hello,

    I built an app that performs the followings: 

     

    Each day it loads an excel file that contains a list of active employees  and then saves the file into QVD file and names it emp_20250109 (the key 20250109 is derived from the file date 09/01/2025)

    On the next day another excel file is loaded  and then  saved in into another QVD file named  emp_20250110 and so on...

    If certain employee was included in emp_20250109 but not inemp_20250110 , that means the employee went Non_active on 10/01/2025.

    The purpose of the app is eventually to count in each month how many employees went Non_active.

    Any ideas on how to approach this ?

     

    Best regards,

    Sharbel 

       

    Show Less
  • forum

    QlikView Administration

    Trying to purchase Qlikview standalone license

    I am trying to purchase a standalone Qlikview License to support some legacy work done in Qlikview and need this urgently to transfer over some old QV... Show More

    I am trying to purchase a standalone Qlikview License to support some legacy work done in Qlikview and need this urgently to transfer over some old QV files to the latest version of QV on a newer machine.  The older files are using the personal edition.

    I have tried calling and leaving messages, emailing QV etc but have not gotten any response.

    Any suggestions how I can go about doing this?


    Thanks for any help/assistance.

    Show Less
  • forum

    App Development

    Vizlib Table and Pivot Tables Issues

    I am using Vizlib Pivot Table v3.8.2 and Vizlib Table v3.23.3. I have problems in each that I need help getting solved. First with the pivot table, de... Show More

    I am using Vizlib Pivot Table v3.8.2 and Vizlib Table v3.23.3. I have problems in each that I need help getting solved. First with the pivot table, despite setting the column to fit to the data, the data still gets cut off with the columns. In part, I believe this is because I have quite a few columns in the pivot table fully expanded and there is no horizontal scroll option available, despite the settings saying so. Second, the Vizlib table doesn't give me the options to change the colors of the columns which, only the rows. This may be because I have the enable merge feature selected. Is there any way around either of these either?

    Show Less
  • forum

    Qlik Replicate

    Request for Documentation: Internal Parameters for Endpoint-Level Data Type Conf...

    I’m working on modifying an endpoint in Qlik Replicate using internal parameters within the Advanced Settings at the endpoint target level. The primar... Show More

    I’m working on modifying an endpoint in Qlik Replicate using internal parameters within the Advanced Settings at the endpoint target level.

    The primary goal is to address an issue where metadata tables being generated in Snowflake are appearing in an incompatible format. This issue cannot be resolved at the global parameters level because global parameters only apply to the task-level tables. Instead, I want to configure the endpoint so that any table created, altered, or dropped adheres to a specific format.

    Here’s what I’ve achieved so far:

    • I successfully used the following internal parameters to manage table creation, alteration, and drop operations:
      • $info.query_syntax.create_primary_key
      • $info.query_syntax.create_table
      • $info.query_syntax.drop_table

    However, I’m facing challenges in configuring data type conversions at the endpoint level, particularly:

    1. Adjusting the precision of VARCHAR fields (e.g., setting them to VARCHAR(16777216) or ensuring max length for Iceberg compatibility).
    2. Modifying datetime and timestamp data types (e.g., setting all timestamps to TIMESTAMP(6)).

    I’ve been unable to find documentation that lists all available internal parameters and examples for data type adjustments. I’ve seen partial references in the community but no comprehensive documentation.

    Could you please provide:

    • A list of internal parameters available for endpoint-level configurations.
    • Examples or documentation specifically showing how to alter data types (e.g., VARCHAR precision or datetime adjustments) at the endpoint level.

    This would greatly help in developing tasks that align with Iceberg table requirements in Snowflake.

    Thank you for your assistance!

    Show Less
  • forum

    Alerting

    Customize Email Alerts

    Does anyone know if it's possible to customize the emails sent for Alerts? Specifically, I want to remove anything that mentions Qlik (images, text, s... Show More

    Does anyone know if it's possible to customize the emails sent for Alerts? Specifically, I want to remove anything that mentions Qlik (images, text, sender name, etc.) and only keep the title of the alert and the data that caused it to trigger.

    Qlik Alerting 

     

    Show Less
  • forum

    Qlik Replicate

    Failed to receive : An existing connection was forcibly closed by the remote hos...

    Hi guys,I'm receiving this error while replicating data from oracle DB as source, but tasks seems to be running, what may be the underlying issue?Than... Show More

    Hi guys,

    I'm receiving this error while replicating data from oracle DB as source, but tasks seems to be running, what may be the underlying issue?


    Thanks,

    Sreehari

    Show Less
  • forum

    Qlik Enterprise Manager

    Setup Qlik server on new Domain.

    Hi All, We have Qlik Sense server running in old domain. We have taken the repository data base backup and installed Qlik Sense server on new domain. ... Show More

    Hi All,

    We have Qlik Sense server running in old domain. We have taken the repository data base backup and installed Qlik Sense server on new domain. After installation i applied the backup which we have taken from old server and restarted the Qlik server.

    I executed all command which i have listed below.

    cd "G:\Program Files\Qlik\Sense\Repository\PostgreSQL\14\bin"

    Run the following commands in order to drop and then create the database:

    Drop database (if one exists):

    dropdb.exe -h localhost -p 4432 -U postgres QSR​

    Create temp database:

    .\createdb.exe -h localhost -p 4432 -U postgres -T template0 QSR​

    Restore the database by running the following command:

    pg_restore.exe -h localhost -p 4432 -U postgres -d QSR "<Path>\QSR_backup.tar"

    Start the Qlik Sense Service Dispatcher.

    cd "G:\Program Files\Qlik\Sense\Repository\

    Repository.exe -bootstrap -standalone -restorehostname

    After That when i am trying to open QMC its open but everything disabled

    jrathgebercs_0-1737022330648.png

     

    Could you please suggest me what need to do to enable everything.

    Note: In the new domain server. user directory table name will be different.

    Regarding,

    Irshad Ahmad

    Show Less
Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

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!