Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 218,863 members
  • 6,573 online
  • 1,997,413 posts
  • 149,741 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • 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
  • 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

    Qlik Cloud Data Integration

    Using a KPI inside of an Org Chart

    Hi - I am using an Org Chart Custom Object from the Qlik Visualization Bundle. I was wondering if I could place a KPI inside the org chart so that cli... Show More

    Hi - I am using an Org Chart Custom Object from the Qlik Visualization Bundle. I was wondering if I could place a KPI inside the org chart so that clicking it navigates the user to a different sheet inside of the app. The reason I am asking this is because our org chart is large and I would like to have different divisions on different sheets.

    I would like to have the tree look something like this:

    President
    |
    v
    CFO
    |
    V

    "Click here for Finance Department Org Chart" KPI that navigates to a different sheet

    Show Less
  • forum

    App Development

    Cant able to create a common date

    Hi everyone  i am creating a Pie chart where i need a common year filter i already tired with Canonical Date data is coming wrong       Show More

    Hi everyone 

    i am creating a Pie chart where i need a common year filter i already tired with Canonical Date data is coming wrong

     

    ha142000_0-1715118700354.png

     

     

    Show Less
  • forum

    App Development

    Filter Pivot Table with Button

    I currently have a Pivot Table that is displaying the total number of records in different work queues, broken down by their current SLA status (Green... Show More

    I currently have a Pivot Table that is displaying the total number of records in different work queues, broken down by their current SLA status (Green, Yellow & Red).  Sample screenshot shown below:

    trevorcrow_0-1715116426998.png

     

    What I'm trying to accomplish, if possible, would be to have a couple of Qlik buttons that could perform filtering of what is being displayed on the Pivot Table.  For example, Button 1 could filter out any Queues with zero records.  Button 2 would filter the pivot table to only display queues that have records in a Red SLA status.  Is this possible?  I've tried numerous things that I've found online but haven't found the right answer or example yet.  

    Thanks for any assistance that can be given!

    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!