Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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?
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.
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
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 |
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
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!
マップの機能を用いて日本の市区町村単位(今回は九州地方の焦点宛てたい)
でエリアレイヤーを設定したいのですが、どのように実装をすればよいでしょうか。
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
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 *.
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Help us improve your Qlik experience by participating in our customer survey! The survey will be live from May 27 - June 14.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
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.
Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!