Skip to main content

Welcome to
Qlik Community!

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

Welcome to Qlik Community

Recent Discussions

  • 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

    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

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

    New to Qlik Analytics

    Name of an object

    Hei, I have somewhere seen an object that could hold a lot of values like a table.  Every measure could be written separately. How you please help me ... Show More

    Hei,

    I have somewhere seen an object that could hold a lot of values like a table. 

    Every measure could be written separately.

    How you please help me out?

    MindaugasBacius_0-1712915559442.png

    P.S. Qlik Sense on prem version

     

    Show Less
  • forum

    App Development

    Sort Data Based on Number of Leading Zeros

    Hi All, How to sort data based on leading zeros and not the actual number in qlik Below is my example Item Num 0064 000670402 0065FR CS-CD-... Show More

    Hi All,

    How to sort data based on leading zeros and not the actual number in qlik

    Below is my example

    Item Num
    0064
    000670402
    0065FR
    CS-CD-PSW-10-00
    010240410

    The data should be sorted based on number of zeros at the start in ascending order.

    My final output should be like the below table

    Item Num
    000670402
    0064
    0065FR
    010240410
    CS-CD-PSW-10-00

    Note : This is just an example . I have more that 30000 item numbers like this and i want to sort based on number of leading zeros

    Show Less
  • forum

    New to Qlik Analytics

    Load exact patitioned QVD-file in ODAG

    Hi, everyone!My last question was about making partitions from one QVD to several smaller.And kind user Brunobertels sent me a link to a post, how to ... Show More

    Hi, everyone!
    My last question was about making partitions from one QVD to several smaller.
    And kind user Brunobertels sent me a link to a post, how to do automatic partitions.

    And now, I have many pratitioned QVD-files and task:
    I have to load those QVD-files which have only data by asked dates in ODAG request.

    I just made a next script:

    //first check if it's not an ODAG request, but a common load from current window
    if '$(odagActive)' = '' then
       set 'odag_Date' = '''01.07.2019''';
    end if;

    [Tasks]:

    LOAD
       TaskID,
       ContactID,
       CompanyID,
       CreationDate,
       TaskExpDate,
       EditDate,
       TaskStatus,
       CreatedUserID,
       ResponsibleUserID,
       TaskName
    FROM[lib://DataFiles/CRM_Tasks_*.qvd](qvd)
    where Match(CreationDate,$(odag_Date));

    But as you can see, it's a bad script, coz it loads all the files(((
    Please help me to load exact files with dates which was requested.

    Here's my QVDs:

    lib://DataFiles/CRM_Tasks_m01_y2019.qvd
    lib://DataFiles/CRM_Tasks_m02_y2019.qvd
    lib://DataFiles/CRM_Tasks_m03_y2019.qvd
    lib://DataFiles/CRM_Tasks_m04_y2019.qvd
    lib://DataFiles/CRM_Tasks_m05_y2019.qvd
    etc till the end of 2020.

    Show Less
  • forum

    New to Qlik Analytics

    Geo Map shouldn't affect when select on yearmonth filter

    Hi Everyone, so I have geo map which shouldn't affect when I select year month, So I have provided the expression to ignore this dimension but in size... Show More

    Hi Everyone, so I have geo map which shouldn't affect when I select year month, So I have provided the expression to ignore this dimension but in size&shape properties, there are two layers point layers and area layers, except size&shape all the properties are dimension, so How should I stop the dimension from reflecting from year-month?
    right now after selecting it is removing countrys(area layer) and some station(point layer) when I select year-month.
    Used expression: SUM({<[YEAR_MONTH]=>}[GEO_AVG_PRICE] * [GEO_QTY])

    Before selecting year month filter:

    Lucius_Artorius_Castus_0-1714049906784.png


    after selecting (it shouldn't change anything, It should show the map as it was before as in above image):

    Lucius_Artorius_Castus_1-1714049952275.png

     

    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!