Skip to main content

Welcome to
Qlik Community!

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

Welcome to Qlik Community

Recent Discussions

  • 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
  • forum

    App Development

    Datos no coincidentes(Join)

    Buen día comunidad   Requiero ayuda con lo siguiente, tengo dos tablas:   Historico: con el campo ID:[1,2,3,4,5] Mes: ID[1,2,6,7,8] No he podido halla... Show More

    Buen día comunidad

     

    Requiero ayuda con lo siguiente, tengo dos tablas:

     

    Historico: con el campo ID:[1,2,3,4,5]

    Mes: ID[1,2,6,7,8]

    No he podido hallar la forma de cruzar las dos tablas para obtener los registros no coincidentes, lo que deseo es saber mediante un script los registros de la tabla del Mes que no están en el Histórico 

     

     

     

    Show Less
  • forum

    App Development

    in filter, display the pre-mapped values, but filter by mapped-value 'behind the...

    I have a map below, which related food to fcode. fcode is the key that links multiple tables together.   map1: [food,fcode apple,a apple-pie,a banana,... Show More

    I have a map below, which related food to fcode. fcode is the key that links multiple tables together.

     

    map1:

    [food,fcode

    apple,a

    apple-pie,a

    banana,b

    banana-float,b

    cherry,c

    cherry-coke,c];

     

    Let's say

    Table 1 -uses fruits (applymap() can be used to turn food into fcode)

    Table 2 -uses fcode (can not reverse into food)

    Table 3 -uses fcode (can not reverse into food)

     

    How can i create a filter, such that:

    1. the filter display the food values. (i.e apple-pie and not 'a')

    2. When selecting food values, the filter is applied to all tables (1,2,3). I.e if I select apple-pie (or apple), the filter also set  fcode to 'a' and table 2,3 will display only information relating to 'a'. Note that it is accepted for either apple-pie or apple to be selected to filter for fcode 'a'

    If I use applymap() on table 1, and filter by fcode, i lose context for my users who only understands food.

     

     

     

    Show Less
  • forum

    Administering and Monitoring

    Custom Banner in Qlik Saas

    Can we create custom banner in Qlik Saas. We have to display message on Hub if there is any planned maintenance or data refresh failure.  This facilit... Show More

    Can we create custom banner in Qlik Saas.

    We have to display message on Hub if there is any planned maintenance or data refresh failure. 

    This facility is available in Enterprise version. But didn't find on qlik SaaS.

    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!