Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have just installed Feb 2024 on a lab server for testing.
Have imported one of our production apps (from Feb 2022 cluster) which uses derived fields for calendar dimensions using the DECLARE FIELD DEFINITION....FIELDS and DERIVE FIELDS FROM FIELDS .... USING .... script construction
There seems to be a bug with the derived fields - it recognises them and shows them in field list but in expression editor it reports an error in expression with red border round field box and when using the derived fields in conjunction with a function - in this case the CLASS function it does not work and returns an error
This all works 100% OK in our Feb 2022 production environment
Has anyone else encountered this ?
Qlik Compose for Data Warehouses
Hi All,
I have run the below command in the bin folder of the Qlik server which is installed in F drive.
My outfolder will be D drive.
ComposeCli.exe export_csv --project WH_Master --outfolder D:\WHPUAT
This command exported all csv files related Model, Mappings and Data Marts only.
It didn't export any files related to Datawarehouse tasks and SQL files and also showed an error
SYS-E-HTTPFAIL This given path's format is not supported..
Could you please help me with this error.
Thanks!
Hi all,
I have this sample dataset from one source. I want to show in a straight chart, just the Store and Systems columns. But I want them to be filtered by the dimension Function that has the value of only 'Fixed Ops'. Any help here would be appreciated, thanks in advance!
We have some python scripts residing in one of the qlik nodes which is connected to qlik sense (which resides in aws server) through analytic connection
is it possible to move those scripts to aws lambda function and establish a connection from Qlik sense enterprise windows ? I believe AWS lambda connector will work with Qlik cloud only.
Hi all,
i'm trying to login to qlik using a JWT token but when i try to post to https://horsadev.eu.qlikcloud.com/login/jwt-session with the the web integration id and the bearer token i get the following error.
the token is made up like this:
user details: name sub and email are the exactly like the console.
any idea of what can go wrong here?
thanks,
Loris
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
Hi,
I am trying to get the data from previous month and also that has a specific condition. I am using this formula:
count({<Column.Variable = {'Condition'}>}Column.Variable), count(InMonth(Date.DateAppointment,today(),-1), [Record_ID]))
I can use both conditions separate but cannot find the way them together to get the records for that specific condition for the previous month.
Thanks,
Hi, I've been stuck on this all day and its driving me nuts. I've gone through similar posts but haven't been able to crack it. Even help from one of my experienced colleagues didn't crack it...
I have calculated the time duration between 2 time stamps. I now want to categorise this time duration.
The first part of the script works fine:
[vw_ngd_consumer_ee_pn_trdb.test_initiate_time] as "RunTime_Initiate_Time",
[vw_ngd_consumer_ee_pn_trdb.test_completion_time] as "RunTime_Completion_Time",
Time(Timestamp([vw_ngd_consumer_ee_pn_trdb.test_completion_time],'YYYY-MM-DD hh:mm:ss')-timestamp([vw_ngd_consumer_ee_pn_trdb.test_initiate_time],'YYYY-MM-DD hh:mm:ss'),'hh:mm:ss') as "NGD Run Time",
Now here's where my issue is. I want to create a new table that categorises this field. Alternatively I could add this categorisation as an extra column in the original dataset, but I thought it might be easier to create a new table. Maybe now?
So the script I've created currently looks like this:
Run_Time_Table:
LOAD
[NGD Run Time],
IF(Time([NGD Run Time]),'hh:mm:ss')<=('00:01:00'),'Less than 1 minute',
IF(Time([NGD Run Time]),'hh:mm:ss')<=Time('00:02:00'),'Less than 2 minutes',
IF(Time([NGD Run Time]),'hh:mm:ss')<=Time('00:03:00'),'Less than 3 minutes',
IF(Time([NGD Run Time]),'hh:mm:ss')<=Time('00:03:00'),'greater than 3 minutes','Unknown' as "RunTime_Category"
Resident [NGD_Test_Data];
This results in the following error message:
I'm completely stumped as to what the issue is. I've checked the field names and I can't see any duplicate fields, but obviously I am using [NGD Run Time] field a few times, but that should be fine?
Can anyone spot where I'm going wrong?
Hi
When a pie chart or a donut chart is natevely created in the PixelPerfect template, there is a bug displaying the last label of the percentage.
In fact if the last percentage and first percentage values are between 1% and 3% than their label get swapped clockwise after the first label. Wrongly displaying the labels.
The Resolve Overlapping Mode property behavior does not move the label to the right side. See attached images.
It happens on all NPrinting versions.
How can this be fixed?
Kind regards
Hatus Peters
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.
Join us on May 15th at 11 AM ET to discuss the Qlik Ideation Process. Bring your questions.
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!