Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 221,550 members
  • 6,664 online
  • 2,001,763 posts
  • 150,098 Solutions
Announcements
Announcing Qlik Talend® Cloud and Qlik Answers™ to accelerate AI adoption! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    NetWorkingDays function with long list of Holidays

    Hi All, I am trying to calculate set up period for several items and would like to measure way back to 10 years ago. I have to take account of working... Show More

    Hi All,

    I am trying to calculate set up period for several items and would like to measure way back to 10 years ago. I have to take account of working days and bank holidays. Each of year we have roughly 8 bank holidays. So if I use networkingdays function, how can I add bank holidays as a list rather than adding one date by date?

    My data looks like below:

      Start date End date
    A 30/01/2024 09/05/2024
    B 17/10/2023 12/02/2024
    C

    02/03/2022

    14/03/2024
    D 01/07/2020 04/06/2023
    E 20/09/2020 23/12/2020
    F 24/05/2021 09/09/2021

     

    And my bank holidays list looks like:

    BH
    01/01/2020
    10/04/2020
    13/04/2020
    08/05/2020
    25/05/2020
    31/08/2020
    25/12/2020
    28/12/2020
    01/01/2021
    02/04/2021
    05/04/2021
    03/05/2021
    31/05/2021
    30/08/2021
    27/12/2021
    28/12/2021
    03/01/2022
    15/04/2022
    18/04/2022
    02/05/2022
    02/06/2022
    03/06/2022
    29/08/2022
    19/09/2022
    26/12/2022
    27/12/2022
    02/01/2023
    07/04/2023
    10/04/2023
    01/05/2023
    08/05/2023
    29/05/2023
    29/08/2023
    25/12/2023
    26/12/2023
    01/01/2024
    29/03/2024
    01/04/2024
    06/05/2024
    27/05/2024
    26/08/2024
    25/12/2024
    26/12/2024

     

    I have tried created a master item as: networkingdays(start date, end date, BH) or a variable from script like: 

    let vBH=concat(BH,',');

    [New table]:

    NetWorkDays([start date], [end date], '$(vBH)') AS [duration]

    Resident [XX];

    None of them are working. Any thoughts?

    Many thanks!

     

    Show Less
  • forum

    Security & Governance

    Taking over a Qlik Tenant

    Himy company is the new Qlik development services provider for a client. Th client had purchased their tenant from an existing Qlik third party provid... Show More

    Hi

    my company is the new Qlik development services provider for a client. Th client had purchased their tenant from an existing Qlik third party providers (OEM Partner i believe) and now as they will no longer be involved, my company needs to take over this tenant and be involved in its further management (purchasing new licenses, capacity etc.). How can we do this?

    Show Less
  • forum

    Deployment & Management

    Qlik Sense Enterprise Upgrade for Security Vulnerability Issue

    Hi, We have Qlik Sense installed in our organisation and we are currently on February 2022 Patch 3. We have been notified that there is a high-severit... Show More

    Hi,

    We have Qlik Sense installed in our organisation and we are currently on February 2022 Patch 3.

    We have been notified that there is a high-severity security vulnerability issue affecting Qlik Sense Enterprise software that could potentially be exploited. We were informed that we should address the issue promptly by installing the latest patch for supported versions of Qlik Sense.

    There are 2 questions:

    1. Based on the current Qlik Sense version we have, are we affected by this security vulnerability issue?

    2. What are the steps to upgrade so we can counter this vulnerability issue?

    Thanks.

    Show Less
  • forum

    Deployment & Management

    Reload task on particular Reload node

    Hi, I am using qliksense enterprise. Is it possible to send a particular reload task to an specific reload node? I have 3 reload nodes and I want to s... Show More

    Hi,

    I am using qliksense enterprise.

    Is it possible to send a particular reload task to an specific reload node? I have 3 reload nodes and I want to send one particular reload task to reload node #3

    Please let me know if anyone has done this.

    Thanks

    Show Less
  • forum

    QlikView Administration

    Reload Engine and Distribution service instability

    Hello Qlik Community,   I ask for your help regarding an evasive issue, regarding the reload engine and distribution service instability, mostly regar... Show More
    Hello Qlik Community,
     
    I ask for your help regarding an evasive issue, regarding the reload engine and distribution service instability, mostly regarding the distribution service.
     
    The symptoms are the following, at seemingly random time of the day, we receive the following alert:
    "QMC on machine XXXXX reports that one or more Qlikview Distribution Services failed to respond. Please check QMC for more info"
    And sometimes, we also receive at the same time another alert:
    "The service 'ReloadEngine@XXXXX ' is down. Service Url is http://XXXXX :4720/QDS/Service"
     
    For the context:
    We were using Qlikview 11.2 until recently, we upgraded to the version 12.9. Initial release, going to 12.7 first and then to 12.8. The problem appeared when we first upgraded to 12.7, and the situation changed with Qlikview 12.8 SR 2 ( 12.80.20200.0).
    The first failed were correlated to an overload of the CPU during the reload of some reports. Since then, we've optimized the queries and overall it reduced the occurrence of the alert, although not completely avoiding it.
    We also, when it first appeared, applied a daily restart of services, which helped but did not solve the problem. We later removed it with the latest version, as it seemed suboptimal in this new setup, which in turns reduced the frequency.
    To get to this point, we followed the guides to help troubleshoot the problem: 
     
     
    It seems that part of it is also related to the reload with Nprinting, triggering the issue.  
    With the 12.8 SR2 version, one of the patch notes seemed to target a similar issue - QV-22417 - QVS crashed intermittently under heavy load and interaction:
    "The QVS server crashed intermittently while evaluating QlikView chart object calculations. 
    This was not caused by any specific calculation but was mainly connected to concurrency around shared chart objects, particularly sessions connecting/disconnecting and fast type changes of linked shared objects. 
    Multiple additional synchronizations and safeguards have been introduced to safely handle sharing sessions attaching and detaching. 
    Shared object with linked (replicated) object type changes have been restricted to safe combinations."
     
     
    After the change from 12.8 IR to 12.8 SR2, the qlikview distribution service fails with the reload engine, changed a little in behaviour:
    It now appears at seemingly random time, without regularity in the time of day, and also more often. Even though 
    the specs of the server have been increased a little, because we also want to shift from using Qlikview Plugin to Ajax for the user to access the reports, and so to keep a margin of memory. 
    The server is using Microsoft windows server 2019 Standard, the CPU is  2.30GHz, over 8 cores, with 72 Gb of memory.
    This server is dedicated to Qlikview and currently still in test, meaning not accessed by end users, only admins.
    We've also tried to cap CPU usage and uncap it (65 %, 95%, 100%) without changes.  Currently, it is capped at 95%.
    We've analyzed the logs as well without finding clues or much trace.
    Following the advice from this guide:
    We've looked up the performance, although it only seems to point to the consequence, with a high CPU consumption after the service failure.
     
    In 12.9, the issue still persists, even with little load on the server except Qlikview, Nprinting and me as the only user connected. 
     
    Has anyone encountered a similar issue or has a clue of what would cause the distribution failure ? 
     
     

     

    Show Less
  • forum

    QlikView App Dev

    Combine 4 Different Tables into 1 Table

    Hi, Can I ask on how do I combine 4 different tables into 1 Table as shown below. I can do the expression formula to put the 4 total into the new tabl... Show More

    Hi,

    Can I ask on how do I combine 4 different tables into 1 Table as shown below.

    I can do the expression formula to put the 4 total into the new table but I do not know how to write the dimension to combine all the tables months since all tables have different months columns.

    Thank you for all your advise and help.

    Table 1

    Month 1 Total 1
    Jan-2023 0
    Feb-2023 0
    Mar-2023 0
    Apr-2023 0
    May-2023 27
    Jun-2023 0
    Jul-2023 0
    Aug-2023 0
    Sep-2023 0
    Oct-2023 0
    Nov-2023 0
    Dec-2023 0

     

    Table 2

    Month 2 Aug-2023 Sep-2023 Oct-2023 Nov-2023 Dec-2023 Jan-2024 Feb-2024 Mar-2024 Apr-2024 May-2024
    Total 2 0 0 0 6,000 0 0 0 0 22,789 7,300

     

    Table 3

    Month 3 Total 3
    Apr-2023 2,556
    May-2023 2,193
    Jun-2023 2,401
    Jul-2023 2,176
    Aug-2023 2,557
    Sep-2023 2,835
    Oct-2023 2,886
    Nov-2023 3,077
    Dec-2023 2,898
    Jan-2024 2,721
    Feb-2024 2,969
    Mar-2024 2,528
    Apr-2024 3,038
    May-2024 3,091

     

    Table 4

    Month 4 Total 4
    Jan-2023 0
    Feb-2023 0
    Mar-2023 0
    Apr-2023 0
    May-2023 1
    Jun-2023 0
    Jul-2023 0
    Aug-2023 0
    Sep-2023 0
    Oct-2023 0
    Nov-2023 0
    Dec-2023 0

     

    Expected Table

      Jan-2023 Feb-2023 Mar-2023 Apr-2023 May-2023 Jun-2023 Jul-2023 Aug-2023 Sep-2023 Oct-2023 Nov-2023 Dec-2023 Jan-2024 Feb-2024 Mar-2024 Apr-2024 May-2024
    Month 1 0 0 0 0 0 27 0 0 0 0 0 0 0 0 0 0 0
    Month 2 0 0 0 0 0 0 0 0 0 0 6,000 0 0 0 0 22,789 7,300
    Month 3 0 0 0 2,556 2,193 2,401 2,176 2,557 2,835 2,886 3,077 2,898 2,721 2,969 2,528 3,038 3,091
    Month 4 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0
    Total 0 0 0 2,556 2,194 2,428 2,176 2,557 2,835 2,886 9,077 2,898 2,721 2,969 2,528 25,827 10,391

     

    Show Less
  • forum

    Qlik Replicate

    Any negative results of upgrading SQL Server ODBC to 18.3?

    Hi Support, I am wondering if there is any negative consequences to upgrading from Microsoft ODBC 18.1 to 18.3. This is in Windows Server and on QR 20... Show More

    Hi Support,

    I am wondering if there is any negative consequences to upgrading from Microsoft ODBC 18.1 to 18.3. This is in Windows Server and on QR 2023.11.0.282. 

    I know that the documentation recommends getting 18.1 which is why I'm wondering if there are negative consequences that require specifically 18.1.

    Regards,

    Mohammed

    Show Less
  • forum

    New to Qlik Analytics

    Relative numbers based on dimension limitation

    Hi, I am trying to create a table to display the values of the top 20 selling items and I have a measure that is going to calculate the sales as share... Show More

    Hi, I am trying to create a table to display the values of the top 20 selling items and I have a measure that is going to calculate the sales as share per total or sales ratio, let's say I have a total of 30 items and I only want to show the statistics for the top 20 items, I've set a limitation of 20 for my dimension and set the measure modifier to 'Relative Numbers', I've also tried this expression 'SUM(Sales) / SUM(TOTAL Sales)'. However, I realized that the returned values are in relative to all the 30 items instead of the 20 items that are limited in the dimension. 

    Below is an example of what I need:
    Exp Sales Table:
    Product | Sales
    A | 30
    B | 10
    C | 25
    D | 25
    E | 10

    Let say I want the stats for the top 3 selling product, it should have figures as table below:
    Product | Sales | Sales%
    A | 30 | 30/(30+25+25) = 37.5%
    C | 25 | 25/(30+25+25) = 31.25%
    D | 25 | 25/(30+25+25) = 31.25%

    But instead, I am getting figures as below:
    Product | Sales | Sales%
    A | 30 | 30/(30+25+25+10+10) = 30.00%
    C | 25 | 25/(30+25+25+10+10) = 25.00%
    D | 25 | 25/(30+25+25+10+10) = 25.00%

    How can I get the relative value of the limited 20 items or is there a workaround for this? Any help is appreciated!

    Show Less
  • forum

    App Development

    市区町村単位のエリアレイヤーの実装法にについて

    マップの機能を用いて日本の市区町村単位(今回は九州地方の焦点宛てたい)でエリアレイヤーを設定したいのですが、どのように実装をすればよいでしょうか。MAPに日本の市区町村単位でエリア分けをし、その詳細情報を参照できるようにしたい現在利用しているQlik Sense Serverのバージョンは以下です ... Show More

    マップの機能を用いて日本の市区町村単位(今回は九州地方の焦点宛てたい)
    でエリアレイヤーを設定したいのですが、どのように実装をすればよいでしょうか。

    MAPに日本の市区町村単位でエリア分けをし、その詳細情報を参照できるようにしたい


    現在利用しているQlik Sense Serverのバージョンは以下です
     Qlik Sense May 2024

    質問1)
    エリアレイヤーを用いて実装をする場合どのように実装すればよいか
    ・必要なデータの取得元はあるか(地域の情報)
    ・データの入力の方法(例えば、各市区町村の住民が何人いるかの情報を出すようなアプリがあれば)
    ・エリアレイヤーでは実現できないか

    質問2)
    ・必要なデータの取得元はあるか(地域の情報)
    ・エリアレイヤーで実現できない場合、ポイントレイヤーで実現できるか

    質問3)
    ・その他の方法での実装方法はあるか、


    以下のサイト参考にしておりますが、うまくMAPにプロットできておらずお知恵をお借りしたいです。
    https://help.qlik.com/ja-JP/sense/May2024/Subsystems/Hub/Content/Sense_Hub/Visualizations/Map/Map-HowIBuiltThis.htm

    Show Less
  • forum

    Security & Governance

    Section Access

    Hi   I am new to Qlik and want to know more about section access. I am tasked with writing a section access code which is suppose to provide reduction... Show More

    Hi

     

    I am new to Qlik and want to know more about section access. I am tasked with writing a section access code which is suppose to provide reduction on two fields. When i use blank for GROUPS and later check the testing sheet i dont get correct values i the filter. However, if i use * , then it seems to work. What is the difference between using blank and *.

    Show Less
Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

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!