Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 216,943 members
  • 6,788 online
  • 1,994,340 posts
  • 149,441 Solutions

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Replicate

    Failed to remove file:

    Today we had an error on one of our Qlik Replicate tasks "Failed to remove file:" Processing aborted due to error 300002:1355844283; incident 3722464.... Show More

    Today we had an error on one of our Qlik Replicate tasks "Failed to remove file:" 
    Processing aborted due to error 300002:1355844283; incident 3722464.
    to execute statement: REMOVE @"PROD"."PUBLIC"."ATTREP_IS_PROD_bf071f72_b1f9_4dc7_b2f8_919759658d9c"/bf071f72_b1f9_4dc7_b2f8_919759658d9c/0/CDC00000215.csv;

     

    What does this error mean?  

    Show Less
  • forum

    New to Qlik Analytics

    Display alternate text for NULL

    Hi, I have a fact table (f_table) and dimension table (d_table) with below fields. f_table: country_cd, measure_1 d_table: country_cd, country_desc In... Show More

    Hi,

    I have a fact table (f_table) and dimension table (d_table) with below fields.

    f_table: country_cd, measure_1

    d_table: country_cd, country_desc

    In Qlik Sense data manager, I associate both the tables on country_cd field. 

    Now I add a bar chart to display measure_1 against country_desc. There are many country codes in my fact table which are not in dimension table. All these are displayed against '-' in my bar chart. But I want to display it as 'Unknown'.

    QS - Question.jpg

    I tried changing the dimension (in bar chart) from just "country_desc" to "if(isnull(country_desc), 'Unknown',country_desc)" but it does not help.

    Appreciate any suggestions. Thanks!

    Show Less
  • forum

    Qlik Enterprise Manager

    compatibility question

    Hello, Is it possible to have a Qlik Enterprise manager version November 2023 hosted on a Windows server, that manages Linux hosted Qlik Replicate ser... Show More

    Hello,

    Is it possible to have a Qlik Enterprise manager version November 2023 hosted on a Windows server, that manages Linux hosted Qlik Replicate server, version May 2022?

    Show Less
  • forum

    Qlik Cloud Data Integration

    ServiceNow data connection issue

    HiI'm trying to connect ServiceNow data in Qlik cloud,I was able to connect to ServiceNow instance I see tables but when I click on any of them to see... Show More

    Hi

    I'm trying to connect ServiceNow data in Qlik cloud,
    I was able to connect to ServiceNow instance I see tables but when I click on any of them to see details and pick columns there is nothing but a spinning circle and an error about Qlik Sense error.

    Show Less
  • forum

    New to Qlik Analytics

    Times

    Hi, what do i miss here??if(frac(STARTTIME)>=MakeTime(6,45) and frac(STARTTIME)<=MakeTime(15,29,59),'FM',if(frac(STARTTIME)>=MakeTime(15,30) and frac(... Show More

    Hi, what do i miss here??

    if(frac(STARTTIME)>=MakeTime(6,45) and frac(STARTTIME)<=MakeTime(15,29,59),'FM',
    if(frac(STARTTIME)>=MakeTime(15,30) and frac(STARTTIME)<=MakeTime(22,59,59),'EM','Natt')) as Shift

    JohnSSI_0-1713197425254.png

    JohnSSI_1-1713197531018.pngJohnSSI_2-1713197626578.png

     

     

    Show Less
  • forum

    New to Qlik Analytics

    Exclude fields in the calculation?

    How do I create an expression similar to the following? sum({<Field1={Test1}, [Field2]<>[Field3]>} [Field4]))    Field4 should be displayed if Field2 ... Show More

    How do I create an expression similar to the following?

    sum({<Field1={Test1}, [Field2]<>[Field3]>} [Field4])) 

     

    Field4 should be displayed if Field2 and Field3 are not equal. If I create an expression as above, I get an error because <> is not a valid relational operator.

    How do I create this correctly?

    Show Less
  • forum

    New to Qlik Analytics

    Filter in a table

    Hello,I want my users to be able to add a favorite that selects all the elements in a column > 90. But when I try this, and select 'select all the pos... Show More

    Hello,

    I want my users to be able to add a favorite that selects all the elements in a column > 90. But when I try this, and select 'select all the possible values', it selects all the values of the column without taking in consideration the >90.

    clarachac_0-1713281871858.png


    Show Less
  • forum

    Design and Development

    Talend Studio: Job hierarchy - How do I know if a Job is a Master Job?

    Hello everyone, How do I know if a Job is a "Master" Job, meaning it is not being called from any other Job?I'm using Talend Studio and I know there i... Show More

    Hello everyone,

    How do I know if a Job is a "Master" Job, meaning it is not being called from any other Job?
    I'm using Talend Studio and I know there is an option accessible by right-clicking on a Job to "Open Job Hierarchy". It shows the flow starting from that Job onwards. But it doesn't show if that particular Job is being called by another Job.
    So, my question is: how do I know if a Job I'm looking at is being called by another Job, thus being its child.

     

    Thank you so much.

    Rui
     

    Show Less
  • forum

    New to Qlik Analytics

    Default filter

    Hello, I have used filter panes in one of my sheet in qliksense. One of the filters is to select Gender. The filed name in my data source is Gender an... Show More

    Hello,

    I have used filter panes in one of my sheet in qliksense. One of the filters is to select Gender. The filed name in my data source is Gender and it has rows for F (as female) and M( as male). Previously, I had this expression behind my filter 
    if(Gender='F','Female',if(Gender='M','Male')). it works fine.

    Now user wants that every time they open the sheet it filters out the report automatically or by default to Male. and later, if they need then change and select the Female option in the filter.

    I have set this variable in the main section in data load editor SET vDefaultFilter='Male', and modify the expression like this: if(Gender='F','Female','$(vDefaultFilter)')

    the expression says ok but it does not filter data by default to Male. I still need to go and select Male option.

    could someone help please?

    Thank you!

    Show Less
  • forum

    Qlik Replicate

    QlikReplicate to connect the Google Bigquery

    I am trying to connect to google BQ I am successfully able to create ODBC connection but not from qlikreplicate getting this error SYS-E-HTTPFAIL, Can... Show More

    I am trying to connect to google BQ I am successfully able to create ODBC connection but not from qlikreplicate getting this error

    SYS-E-HTTPFAIL, Cannot connect to ODBC provider.
    SYS,GENERAL_EXCEPTION,Cannot connect to ODBC provider,RetCode: SQL_ERROR SqlState: 08001 NativeError: 10380 Message: [Simba][ODBC] (10380) Unable to establish connection with data source. Missing settings: {[KeyFilePath_Enc]}
     

    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!