Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 218,918 members
  • 6,587 online
  • 1,997,525 posts
  • 149,753 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

    Unable to access the URL for Qlik Replicate.

    Hi Team, We're facing some issues with our Replicate installation on Red Hat Linux. We're unable to stop or restart services, and we're also having tr... Show More

    Hi Team,

    We're facing some issues with our Replicate installation on Red Hat Linux. We're unable to stop or restart services, and we're also having trouble accessing the Qlik Replicate Console. Any assistance you can provide would be greatly appreciated. When we kill process id after that we are able to start service also access URL what can be cause for this 

    Thanks!

    Show Less
  • forum

    Move to SaaS

    How can we connect to local folders in Qliksense SAAS

    Hi Team, I have a seperate server, where i need to store all the QVD files generated in Qliksense SAAS, in data connections in qliksense we have a fol... Show More

    Hi Team,

    I have a seperate server, where i need to store all the QVD files generated in Qliksense SAAS, in data connections in qliksense we have a folder connection available, how can we achieve this in qliksense SAAS.

    Show Less
  • forum

    Qlik NPrinting

    NPrinting issues with Qliksense Container, straight Table with Chart Exploration...

    1. I am using container having 3 different charts ,In NPrinting report first and last tab are rendering, but middle one NOT rendering , this occurs in... Show More

    1. I am using container having 3 different charts ,In NPrinting report first and last tab are rendering, but middle one NOT rendering , this occurs in other containers as well in my Qliksense application.?

    2. Cannot apply alternative dimensions in Barchart,in NPrinting -only return/render Barchart with default dimension. ?

    3. Straight Table with Chart Exploration: NPrinting only return the 3 default columns, which is available in chart Exploration in straight Table?

    4. Straight Table Extension with chart exploration is an extension? Can you confirm same extn supported by NPrinting May 2023 SR2 Version.? 

    My core Qliksense application version is May 2023 Patch 6 . 

    Show Less
  • forum

    Qlik NPrinting

    Dynamic tables with calculated dimensions,org chart extension objects are not re...

    I am using NPrinting May2023 SR2 version, org chart extension, dynamic tables with calculated dimensions in adhoc reporting are not not supported in e... Show More

    I am using NPrinting May2023 SR2 version, org chart extension, dynamic tables with calculated dimensions in adhoc reporting are not not supported in excel, objects or tables are not rendering properly ,Do you have any solution?

    Show Less
  • forum

    New to Qlik Analytics

    Trouble with Incremental Data Loading into QVD File

    Hello community, I'm having trouble adding incremental data into a QVD file named YH1.qvd. Here's the code I'm using: TableYH1:Load *FROM [lib://DataF... Show More

    Hello community,

    I'm having trouble adding incremental data into a QVD file named YH1.qvd. Here's the code I'm using:

    TableYH1:
    Load *
    FROM [lib://DataFiles/YH2.qvd]
    (qvd);

    concatenate

    LOAD
    *
    FROM [lib://DataFiles/YH1.qvd]
    (qvd);

    store TableYH1 into [lib://DataFiles/YH1.qvd] (QVD);

     

    The issue is that I'm unable to change YH1.qvd. Can someone help me understand what's wrong?

    Regards
    Bhavya

     

    Show Less
  • forum

    App Development

    Creating a variable in text box to display current Month-Year

    I have a variable set as vCurrentMonth showing 19 which is the Date.Chron.Month value.  I would like a textbox to display the value for Date.Month.Yea... Show More

    I have a variable set as vCurrentMonth showing 19 which is the Date.Chron.Month value. 

    I would like a textbox to display the value for Date.Month.Year (May-2024) through using the vCurrentMonth variable. 

    Does anyone have any suggestions on how this may be done? 

    Thanks in advance! 

    Date.Chron.Month Date.Period Date.Month.Long Date.Month.Short Date.Year Date.Month.Year
    19 7 May May 2024 May-2024
    Show Less
  • forum

    App Development

    Qlik Environment

    Good day We have an environment where we are using Qlik Sense client managed, Qlik Cloud and Qlik Data Gateway. We are creating reports on Qlik client... Show More

    Good day

    We have an environment where we are using Qlik Sense client managed, Qlik Cloud and Qlik Data Gateway. We are creating reports on Qlik client managed (where we have a connection created to the SQL database). Once the apps are created we then distribute to Qlik Cloud where users view the apps. We are also hoping to then integrate our Qlik apps to our company website for clients.

    Is this the most efficient way to develop the Qlik platform? Or does anyone have advise on how this could be improved?

    Show Less
  • forum

    Qlik Application Automation

    Issue creating file on FTP server

    Hi!I have an issue with creating files on an FTP server using Qlik Automations. It is possible for me to list and read existing files from the FTP but... Show More

    Hi!

    I have an issue with creating files on an FTP server using Qlik Automations. 

    It is possible for me to list and read existing files from the FTP but when I try to create a file I get the error:
    fopen(): SSL operation failed with code 1. OpenSSL Error messages: error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed

    I thought first maybe that the credentials I am using don't have authorization to create or add files but when I'm trying it through WinSCP it works without any problems. 
    I have talked to the person responsible for the FTP server and they tell me that it should not be any issue for the credentials I use. 

    Do anyone know what the issue may be?

    Thanks in advance,

    Adam J.

    Show Less
  • forum

    New to Qlik Analytics

    Filtering data In QV

    Hello All, I have two variables in my Include fileLET vNumOfYears = 4;LET vStartDate = date(Yearstart(AddYears(Today(),-$(vNumOfYears))),'YYYY-MM-DD')... Show More

    Hello All, 
    I have two variables in my Include file

    LET vNumOfYears = 4;
    LET vStartDate = date(Yearstart(AddYears(Today(),-$(vNumOfYears))),'YYYY-MM-DD');

    Currently I am taking last 4 years of data, but now I just want to show Current Quarter+ last 4 Quarters of data
    I want to remove taht 4 in NumOfYears and add my new condition there (4 quarters before + current quarter )

    I need to show that in above variables

    Please help to get this

    thanks!!


    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!