Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 219,161 members
  • 7,460 online
  • 1,997,975 posts
  • 149,789 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    Derived Fields not working in Qlik Sense Feb 2024 IR

    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... Show More

    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 ?

    Show Less
  • forum

    Qlik Compose for Data Warehouses

    Facing Issues with CLI export commands during Migration

    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.... Show More

    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!

     

     

    Show Less
  • forum

    App Development

    Filter Chart using dimensions only

    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 f... Show More

    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!

    Show Less
  • forum

    App Development

    can we replace Analytic connection with python scripts in server with aws la...

    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 connecti... Show More

    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.

    Show Less
  • forum

    Integration, Extension & APIs

    JWT 401 unauthorized

    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 i... Show More

    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.

    LorisLombardo87_0-1715252504937.png

    the token is made up like this:

    LorisLombardo87_2-1715252675807.png

    user details: name sub and email are the exactly like the console.

    any idea of what can go wrong here?

     

    thanks,

    Loris

    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

    QlikView App Dev

    Calculate Easter Dates

    Hi!Is there a way to calculate automatically Easter dates for every year (in past and in future)?Thanks!
  • forum

    New to Qlik Analytics

    Two conditions on Text Box - QlikView

    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 = {'Condi... Show More

    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,

    Show Less
  • forum

    New to Qlik Analytics

    Problems categorising timestamps

    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 o... Show More

    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:

    davehutchinson_0-1715347837222.png

     

    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?

     

     

     

    Show Less
  • forum

    Qlik NPrinting

    PixelPerfect pie chart bug on percentage label

    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 ... Show More

    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

    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!