Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 ?
What might I be doing wrong?
Very frustrating!!
Thanks
Mark
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!
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.
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 .
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?
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
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 |
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?
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.
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!!
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
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.
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.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!