Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 217,864 members
  • 9,311 online
  • 1,995,861 posts
  • 149,586 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Replicate

    Creating Metadata Manager's utility components failed

    I am Trying to do CDC Load with ODBC Connection, After selecting the tables when i am trying to run the job it gets failed with below error.   Creatin... Show More

    I am Trying to do CDC Load with ODBC Connection, After selecting the tables when i am trying to run the job it gets failed with below error.

     

    Creating Metadata Manager's utility components failed
    Cannot create the source utility component
    Failed while preparing stream component 'QAD_PERU'.
    Context field(s) are not defined

     

     

    Attaching the log screenshot.

    Show Less
  • forum

    Qlik Application Automation

    Getting error while reloading the application Automation Monitoring app

    I'm encountering an error while reloading the application Automation Monitoring app. It is used to work properly, but for the past8 days, i have been ... Show More

    I'm encountering an error while reloading the application Automation Monitoring app. It is used to work properly, but for the past8 days, i have been getting this error. Could you please help me to understand the issue?

    Sharan_0-1713947028906.png

     

    Show Less
  • forum

    Deployment & Management

    Qlik Sense disconnection on NLB (F5) with firefox only

    Hello, I'm using Qlik Sense Enterprise February 2024 with a multi nodes deployment. I have some disconnection issues after 5 minutes of inactivity, wi... Show More

    Hello,

    I'm using Qlik Sense Enterprise February 2024 with a multi nodes deployment.

    I have some disconnection issues after 5 minutes of inactivity, with Firefox only, after opening a QS app passing by the NLB (F5) address.

    If I try to connect directly to the address of one of my nodes, I don't have this disconnection issue.

    In the AuditActivity_Proxy log, a specific message is visible each time i'm disconnected :

    Emmanuel_DORR_0-1714057624644.png

    I found some articles about Websocket ping intervall depending on browser, but I really think that it comes more from a parameter at the load balancer level. However, I don't understand why this issue only concerns a particular browser (Firefox) in my case.

    Session inactivity timeout is fixed on 30 minutes on each node :

    Emmanuel_DORR_1-1714057624645.png

    Keep alive timeout is fixed on 10 seconds :

    Emmanuel_DORR_2-1714057624645.png

    Can you give me some ideas to explore in order to resolve this issue?

    Thanks,

    Emmanuel

    Show Less
  • forum

    Qlik Replicate

    Impact on Qlik Replicate if I activate audit trail in DB2

    Hi All, I have DB2 data source and we implemented Qlik replicate. Now DB team is asking for enable audit trail they want to know is any impact will co... Show More

    Hi All, I have DB2 data source and we implemented Qlik replicate. Now DB team is asking for enable audit trail they want to know is any impact will come on Qlik replicate.

    Show Less
  • forum

    Qlik Application Automation

    Does it support deploying or re-running tasks on ubuntu

    We have the following questions.1. whether it can be deployed on ubuntu servers to schedule tasks on a regular basis.2. Is it possible to have an inte... Show More

    We have the following questions.
    1. whether it can be deployed on ubuntu servers to schedule tasks on a regular basis.
    2. Is it possible to have an interface to view the execution process of each node for the executed tasks?
    3. if there is an error on a node, does it support re-execution from the error node?

    Show Less
  • forum

    Security & Governance

    User Email display in the sheet

    I am new to Qlik and i am testing for section access. In my sheet (for testing purposes), I want to display the email of the user who is looking at th... Show More

    I am new to Qlik and i am testing for section access. In my sheet (for testing purposes), I want to display the email of the user who is looking at the sheet. Basically, i want to show the users email id (which is defined in section access) on a text&image object in the qlik sheet.

    Show Less
  • forum

    Qlik Replicate

    Parallel load with ADLS target

    Hi, I'm wondering about a certain scenario. Say for example, there is a large table that needs to go to an ADLS target using parallel load, and there ... Show More

    Hi,

    I'm wondering about a certain scenario.

    Say for example, there is a large table that needs to go to an ADLS target using parallel load, and there are 5 parallel segments. 

    Is there a possibility of say segment 4 loading before segment 3? Thus resulting in incorrect sequence in ADLS.

    Also, are there any best practices regarding loading very large static tables to ADLS? My only current idea is parallel load. Thank you

    Regards,

    Mohammed

    Mohammed

    Show Less
  • forum

    New to Qlik Analytics

    Splitting single input column into multiple columns

    Greetings. Is it possible to split data on the load coming in from excel in a single column (InputField) into multiple columns using the blank rows be... Show More

    Greetings.

    Is it possible to split data on the load coming in from excel in a single column (InputField) into multiple columns using the blank rows between questions as a delimiter?

    Current...

    InputField

    1. Question1?      

    ____ Yes, we use this practice today

    ____ No, we have a different practice in place
     
    2.  Question2?      
    ____ Yes, they can do this independently in all scenarios       
    ____ Yes, they can do this independently in some scenarios      
     
    3. xxxxxx

     

    Desired...

    newcolumn1 newcolumn2

    Question1

    ____ Yes, we use this practice today

    ____ No, we have a different practice in place

     

    Question2

    ____ Yes, they can do this independently in all scenarios

    ____ Yes, they can do this independently in some scenarios

     

     

     

    Show Less
  • forum

    New to Qlik Analytics

    how to add sheet background image using html and CSS in Qliksense

    Hi All, I have sheet and i want to add images as sheet background. there is no option in sheet properties in my current version in my organization. I ... Show More

    Hi All,

    I have sheet and i want to add images as sheet background. there is no option in sheet properties in my current version in my organization.

    I am trying to add using html and css but it's not working properly.

    .qv-panel-sheet {
    background-image: url("C:\Users\Desktop\1600w--kbTNqEWceg.png");
    }

    Can you please suggest me how to do this scenario in Qliksense.

     

    Thanks & Regards,

    Lakshman 

    Show Less
  • forum

    New to Qlik Analytics

    Accumulate and calculate running numbers from ingoing balance and running change...

    Hi, I'm working on financial KPI's and want to use the balance sheet as well as the P&L for analysis. The differences is that in the balance sheet you... Show More

    Hi,

    I'm working on financial KPI's and want to use the balance sheet as well as the P&L for analysis.

    The differences is that in the balance sheet you have an ingoing balance and then the changes during the month is booked and then you get an outgoing balance, in my dataset there is no ingoing balances available from the database from any tables that I've found.

    I want to to a rolling 12 months analysis on inventory turnover rate and need to be able to calculate averages for a twelve months period every month ending to get this KPI. 

    I've added the ingoing balance for 2021-05-01 manually and concatenated with the transaction data, from this I can get an outgoing balance every month with RangeSum and Above where I've set period of times to 100000, (maybe there is a smarter way) which gives me the outgoing balance every month.

    RangeSum(Above(Sum({<Sub_Group={'Inventory'}>}Amount),0,100000),)

    How do I use this? I need to bring the value from 2021-05-01 to 2024-03-31 for example to be able to get my outgoing balance for 2024-03-31, see example below.Qlikbild.png

    Is there a way to make a calculated field instead to use in set analysis or any other way that is more simple just shoot with ideas!

    Help much appreciated, 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!