Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 218,865 members
  • 6,096 online
  • 1,997,418 posts
  • 149,742 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    Bar chart changes color based on the measurement

    The dimensions of the bar chart are Site, Measure 1 is Days1, Measure 2 is Days2, Measure 3 is Days4. I want Days1 to be displayed in white, Days2 in ... Show More

    The dimensions of the bar chart are Site, Measure 1 is Days1, Measure 2 is Days2, Measure 3 is Days4. I want Days1 to be displayed in white, Days2 in green, and Days3 in red. How do I write the color expression?

    mingyu_0-1714960292784.png

     

    Show Less
  • forum

    Deployment & Management

    Is it true that overlapping QPI tool arguments and QPI XML configuration file at...

    I'm working on creating a script file to silently unbundle and upgrade PostgreSQL database in my environment. The Silently installing or upgrading Pos... Show More

    I'm working on creating a script file to silently unbundle and upgrade PostgreSQL database in my environment. The Silently installing or upgrading PostgreSQL using the Qlik PostgreSQL Installer documentation mentions both a list of attributes that could be included in a command to silently unbundle and upgrade PostgreSQL database.

    The arguments and attributes are largely the same. Here's the complete list of arguments and attributes:

    # QPI Tool Argument QPI Config File Attribute Available in Both
    1 acceptQCA N/A No
    2 iprange IpRange Yes
    3 maxconnections MaxConnections Yes
    4 dbinstallationpath DbInstallationPath Yes
    5 dbdatapath DbDataPath Yes
    6 dbbackuppath DbBackupPath Yes
    7 listenaddresses ListenAddresses Yes
    8 dbusername DbUserName Yes
    9 dbuserpassword DbUserPassword Yes
    10 dbsuperuserpassword DbSuperUserPassword Yes
    11 dbhost DbHost Yes
    12 dbport DbPort Yes
    13 qpiconfig N/A No

     

    11 out of 13 arguments/attributes exist in both. I'm assuming that means that those arguments/attributes can either be typed into Command Prompt manually or saved into a configuration file.

    But they shouldn't be typed in both the command and config file.

    Put differently, is it true that overlapping arguments and config file attributes must be provided either in a command or in config file but not in both places? Does anyone know?

    Show Less
  • forum

    App Development

    Date in the wrong order

    After using AutoML to predict weather, I inputted the predicted results and actual temperature table into Qlik Sense. The two are connected by date.  ... Show More

    After using AutoML to predict weather, I inputted the predicted results and actual temperature table into Qlik Sense. The two are connected by date. 

    Formula of date for predicted weater:  

    Date#('202303' & num([automl_row_index]+1,'00'), 'yyyymmdd'), 'yyyy/mm/dd')
    

    Formula of date for actual weater:  

     

    Date( Date#( Year & Num(Month(Date#(Month, 'MMM')),'00') & num(Day,'00') ,'yyyymmddd'), 'yyyy/mm/dd') 
    

     

    Yet, the dates are sorted like this in the filter pane:

    LiquidSword_0-1715121572864.png    

    LiquidSword_1-1715121651805.png

    it is orderd by day instead of month and then day

     

     

    Show Less
  • forum

    Security & Governance

    May 2023 Qlik Sense Enterprise On Windows couldnot install patch 6

    due to find Qlik Sense Enterprise for Windows Remote Code Execution (RCE) Vulnerability (Authenticated). with suggestion we need to install patch 6 to... Show More

    due to find Qlik Sense Enterprise for Windows Remote Code Execution (RCE) Vulnerability (Authenticated). with suggestion we need to install patch 6 to solve this problem. 

    After download the patch and run with administrator on server.  System show logs and installation failed.

    detail see file attached. 

    It is very urgent for me to find a solution.  Any one met same case and solved.

    BS

    jens

    Show Less
  • forum

    App Development

    Timestamp issues

    Hi. I have a timestamp field and I need to keep the time in the field but want to show it in a table with the 24 hour format (preferably without secon... Show More

    Hi.

    I have a timestamp field and I need to keep the time in the field but want to show it in a table with the 24 hour format (preferably without seconds)

    The field is in the database as DD-MM-YY hh:mm:ss

    In Data Manager I can show the date at DD/MM/YY HH:mm

    Markbhai_0-1715124866344.png

     

    Markbhai_1-1715124899109.png

     

    In the load script (for some reason) the format shows as:

    Timestamp(Timestamp#([occured_time], 'DD-MM-YYYY hh:mm:ss') ,'DD/MM/YYYY HH:mm') AS [occured_time],

    In the Qlik Table it shows as a ?

    Markbhai_2-1715124981314.png

     

    What might I be doing wrong?

    Very frustrating!!

     

    Thanks 

    Mark

    Show Less
  • forum

    Qlik Replicate

    HA in Qlik Replicate on Windows

    Hi Team,We are facing an issue while configuring the Qlik replicate environment for High Availability (HA). We are trying installing Qlik Replicate Da... Show More

    Hi Team,
    We are facing an issue while configuring the Qlik replicate environment for High Availability (HA). We are trying installing Qlik Replicate Data folder in the shared storage as per the given article, after that the services are not getting up.


    https://help.qlik.com/en-US/replicate/November2023/Content/Replicate/Main/Clusters/install_replication_in_cluster.htm


    Please connect for better clarity as the steps are not clear from the point of installation.

    Show Less
  • forum

    Qlik Replicate

    QR: Log stream vs header__timestamp

    Hi, Just need a conformation of header__timestamp in regards to reading from the Log stream task: Is the header__timestamp in the S3 json file the ti... Show More

    Hi,

    Just need a conformation of header__timestamp in regards to reading from the Log stream task:

    Jon_Donker_0-1704753381789.png

    Is the header__timestamp in the S3 json file the timestamp of the change on the source? 

    Or the time the change was written to the log stream?

     

    Show Less
  • forum

    Español

    SVG Qlikview

    Estoy con un problema en qlikview, estoy usando o tratando de publicar un tablero con un mapa en svg, en el developer el reporte trabaja bien, el prob... Show More

    Estoy con un problema en qlikview, estoy usando o tratando de publicar un tablero con un mapa en svg, en el developer el reporte trabaja bien, el problema esta cuando entro al publisher, el mapa no se ve.
    ya instale y desinstale the svg extension, ya copie el contenido de la carpeta de la extencion a una ruta dentro del server, y aun asi no logro ver el mapa.
    las direcciones donde esta el contenido del svg son.
    C:\ProgramData\QlikTech\QlikViewServer\Extensions\Objets y C:\Users\administrador\AppData\Local\QlikTech\QlikView\Extensions\Objects.


    Este es el post
    https://community.qlik.com/t5/Qlik-Application-Automation/Publish-Image/m-p/2441326#M3681

    Gracias

    Show Less
  • forum

    Qlik Application Automation

    Publish Image

    Hi QV Community, i need help i hope any one can help me. I have a project to publish a vector image, a map converted to vectors, I have already made t... Show More

    Hi QV Community, i need help i hope any one can help me.

    I have a project to publish a vector image, a map converted to vectors, I have already made the map, it is already connected to the database, on the desktop it works very well, but when I want to see that published image, the report does not show it .

    Any idea, Tks.

    Show Less
  • forum

    Qlik Enterprise Manager

    QEM service can't start - Failed to connect to SQLite repository 'rtdata.sqlite'

    Hi Support,   We have recently seen an issue where the Qlik Enterprise Manager service fails to start with the QEM logs indicating the following error... Show More

    Hi Support,

     

    We have recently seen an issue where the Qlik Enterprise Manager service fails to start with the QEM logs indicating the following error:
    "[ERROR] REPO-E-FACSQLREP, Failed to connect to SQLite repository 'C:\Program Files\Attunity\Enterprise Manager\data\rtdata.sqlite' "

    We were able to resolve the issue by stopping the QEM service and renaming the rtdata.sqlite file to rtdata_old.sqlite, and then renaming the rtdata.new.sqlite file to rtdata.sqlite. After then running the command to upgrade the repository (aemctl.exe repository upgrade), the QEM service was able to run and the console could be accessed.

    Previously when we have seen an issue with a data repository file it has been a result of memory or disk space issues on the server. However, in this case, there have been no reported memory/disk space issues on the server. What we'd like to understand is what are the possible reasons the rtdata.sqlite file becomes unreadable/corrupted.

    This instance of Enterprise Manager is v2023.11.0.259

     

    Thanks,

    Nak

    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!