Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
お世話になっております。
この度、エクステンションの1つであるレイダーチャートについて質問させていただきたく投稿致しました。
Qlik Visualization Bundleに含まれている「Rader Chart」を使用してレイダーチャートを作成しています。
100点×7項目(700点満点) の点数データをレイダーチャートにした際、
メジャー(点数)の上限を「100」にしたところ、
点数の区切り線?が6つ固定になり、17, 33, 50, 67 ,83, 100 という中途半端な区切りになってしまいます。
20.40,60,80,100の5段階(または10,20,30,40,50,60,70,80,90,100 の10段階)にする方法はありますでしょうか?
また、このエクステンションで実現できない場合
希望の形で作成できる他のエクステンションはありますでしょうか?
ご教授お願い致します。
So I am having trouble with visualizing data in a certain way. I'd like to produce something similar to this, except just the actual is stacked.
I have the following tables
1. The Sales Table- https://prnt.sc/10fqy10
2. The Budget Table which stores the year and the target date, and the connection to the store hierarchy https://prnt.sc/10fr03l
3/4. the store and department tables which link the budget to the store/department
What I am hoping to achieve is the following.
on the X axis, i'd like the Budget Year (eg. 2017/2018)
I would like two columns per year
1. The sum of the Budget Amount for the Year
2. A stacked column of the contract_amount, broken down into stage.
My problem is that when I try to make a stacked chart, it also adds the budgeted amount sum, when I want that in a separate column and just stack the contract_amount. I have made this data up to illustrate the problem in the attached excel file.
Is there some way to achieve this? I would be happy to solve with a paid extension if it makes it easier to produce these, I can do it in Excel.
Hi,
I generated (for testing purposes) many files inside SaaS DataFiles folder, about 7,000 qvds. I wanna delete them using a batch command or action, but wihtin SaaS only can delete them one-by-one.
How can I delete about 7.000 files from my tenant?
P.S. I seek a solution in QLIK-CLI, but i didn´t found any command to do that.
Tks,
Pedro
how do i improve load performance or rather make below script more efficient
MAP_SALES_REP:
MAPPING LOAD DISTINCT
TERRITORY_CODE ,
RESPONSIBLE_NAME
FROM [lib://QS_Projects_BA/10_Standard_Data/ALL/10_Shared/10_QVD/20_DIM/D_TERRITORY.qvd]
(qvd);
Map_TERRITORY:
Mapping LOAD Distinct
TERRITORY_CODE,
TERRITORY
FROM [lib://QS_Projects_BA/10_Standard_Data/ALL/10_Shared/10_QVD/20_DIM/D_TERRITORY.qvd]
(qvd);
MAP_SALES_GROUP:
MAPPING LOAD DISTINCT
TERRITORY_CODE ,
TERR_SALES_GROUP
FROM [lib://QS_Projects_BA/10_Standard_Data/ALL/10_Shared/10_QVD/20_DIM/D_TERRITORY.qvd]
(qvd);
MAP_COMMODITY:
MAPPING LOAD DISTINCT
JOB_REFERENCE,
COMMODITY_CODE
FROM [lib://QS_Projects_BA/10_Standard_Data/ALL/10_Shared/10_QVD/20_DIM/D_BL_TO_COMMODITY.qvd]
(qvd);
Map_CARRIER:
Mapping LOAD Distinct
CARRIER_ID as CARRIER_CODE,
CARRIER
FROM [lib://QS_Projects_BA/10_Standard_Data/ALL/10_Shared/10_QVD/20_DIM/D_CARRIER.qvd]
(qvd);
tmp1_CCA_F_BOOKING_COMMERCIAL_LINE:
LOAD
key_CSA,
key_award,
key_bp,
key_shipper,
key_consignee,
key_notify,
key_nac,
key_contract_holder,
key_bkg_party,
key_contract,
key_agency,
key_trade,
key_POL,
key_POD,
key_LEG_POL,
key_LEG_POD,
key_POO,
key_ROO,
key_FPD,
key_ROD,
key_origin,
key_destination,
key_leg_voyage,
key_voyage,
LEG_DATE_TYPE,
// LEG_POL_COUNTRY,
// LEG_POD_COUNTRY,
// LONG_LEG_FLAG,
// LEG_VOYAGE_BOUND_ISSUE_FLAG,
// CSA_ID,
Source,
JOB_REFERENCE,
// SNAPSHOT_FLAG,
// SNAP_DATE,
DateNum,
// DateNum_DIS,
// WTD,
// SALES_ORG_CODE,
// BOOKING_OFFICE,
// TERRITORY_SALES_OFFICE,
// BOOKING_STATUS,
// MYPRICE_FLAG,
SALES_GROUP_CODE,
// SALES_OFFICE_CODE,
// AGENCY_CODE,
// BULLET,
COMMODITY_GROUP,
COMMODITY,
// ORION_COMMODITY,
// PAYMENT_METHOD_CODE,
// PAYMENT_METHOD,
SHIPPING_TYPE,
EQUIPMENT_SIZE_TYPE,
CARGO_TYPE_CODE,
CARGO_TYPE,
// SHIPMENT_CATEGORY,
FULL_EMPTY_CODE,
FULL_EMPTY,
// CONTRIBUTION_RECON_FLAG,
// PRICING_GROUP,
POL_COUNTRY,
POD_COUNTRY,
ORIGIN_COUNTRY,
ORIGIN_COUNTRY_CODE,
DESTINATION_COUNTRY,
DESTINATION_COUNTRY_CODE,
// SALES_OFFICE_COUNTRY_CODE,
// BOOKING_OFFICE_COUNTRY_CODE,
//BOOKING_TYPE,
ACTUAL_CV_TEU_LSTS,
//ACTUAL_CV_TEU,
ACTUAL_CV_LSTS,
ACTUAL_CV_BOX,
ACTUAL_CV_WEIGHT,
// TARGET_CV_TEU,
ACTUAL_CV_NET_CONTRIBUTION,
// TARGET_CV_NET_CONTRIBUTION,
// POTENTIAL_MARKET_TEU,
// TARGET_MARKET_TEU,
// SALES_ORGANIZATION,
FINANCIAL_VOYAGE_SERVICE
, POL.MAIN_BUSINESS_ZONE,
POD.MAIN_BUSINESS_ZONE
// CIF_FOB,
// GA_SEGMENT
FROM [lib://QS_Projects_BA/10_Standard_Data/ALL/10_Shared/10_QVD/40_DTM/30_FACTS/DTM_COMMERCIAL_LINE_Facts.qvd]
(qvd);
RAW_CLGCV06:
LEFT Join (tmp1_CCA_F_BOOKING_COMMERCIAL_LINE)LOAD
CLGCBNO AS JOB_REFERENCE ,
CLGCCARR AS CARRIER_CODE,
"0CRM_TR" AS TERRITORY_CODE
FROM
[lib://QS_Projects_BA/10_Standard_Data/ALL/10_Shared/10_QVD/10_RAW/10_SAP/CLGCV06.qvd]
(qvd);
tmp1.2_CCA_F_BOOKING_COMMERCIAL_LINE:
NoConcatenate LOAD
key_CSA,
key_award,
key_bp,
key_shipper,
key_consignee,
key_notify,
key_nac,
key_contract_holder,
key_bkg_party,
key_contract,
key_agency,
key_trade,
key_POL,
key_POD,
key_LEG_POL,
key_LEG_POD,
key_POO,
key_ROO,
key_FPD,
key_ROD,
key_origin,
key_destination,
key_leg_voyage,
key_voyage,
LEG_DATE_TYPE,
JOB_REFERENCE,
DateNum,
NUM(YEAR(DateNum), '0000') & NUM(MONTH(DateNum), '00')AS MONTH,
NUM(Year(DateNum), '0000') & NUM(Ceil(Month(DateNum)/3), '00') AS QUARTER,
NUM(YEAR(DateNum), '0000') & NUM(WEEK(DateNum), '00') AS WEEK,
NUM(YEAR(DateNum), '0000') AS YEAR,
SALES_GROUP_CODE,
COMMODITY_GROUP,
COMMODITY,
SHIPPING_TYPE,
EQUIPMENT_SIZE_TYPE,
CARGO_TYPE_CODE,
CARGO_TYPE,
FULL_EMPTY_CODE,
FULL_EMPTY,
POL_COUNTRY,
POD_COUNTRY,
ORIGIN_COUNTRY,
ORIGIN_COUNTRY_CODE,
DESTINATION_COUNTRY,
DESTINATION_COUNTRY_CODE,
ACTUAL_CV_TEU_LSTS,
ACTUAL_CV_LSTS,
ACTUAL_CV_BOX,
ACTUAL_CV_WEIGHT,
ACTUAL_CV_NET_CONTRIBUTION,
FINANCIAL_VOYAGE_SERVICE
, POL.MAIN_BUSINESS_ZONE,
POD.MAIN_BUSINESS_ZONE,
ApplyMap('MAP_SALES_REP',TERRITORY_CODE , ' NOT FOUND') AS SALES_REP,
ApplyMap('Map_TERRITORY',TERRITORY_CODE , ' NOT FOUND') AS SALES_TERRITORY,
ApplyMap('Map_CARRIER',CARRIER_CODE, ' NOT FOUND') AS CARRIER_CODE,
ApplyMap('MAP_SALES_GROUP',TERRITORY_CODE, ' NOT FOUND') AS SALES_GROUP,
ApplyMap('MAP_COMMODITY',JOB_REFERENCE, ' NOT FOUND') AS COMMODITY_CODE
, IF (((LEN(TRIM(ORIGIN_COUNTRY_CODE)) = 0 OR ORIGIN_COUNTRY_CODE='NULL' OR ORIGIN_COUNTRY_CODE='-') AND (POL_COUNTRY = 'UNITED STATES' OR POL_COUNTRY = 'CANADA')) OR ((ORIGIN_COUNTRY_CODE = 'US' OR ORIGIN_COUNTRY_CODE = 'CA') AND (POL_COUNTRY = 'UNITED STATES' OR POL_COUNTRY = 'CANADA')), 'EXPORT'
, IF ((((LEN(TRIM(DESTINATION_COUNTRY_CODE)) = 0 OR DESTINATION_COUNTRY_CODE='NULL' OR DESTINATION_COUNTRY_CODE='-') AND (POD_COUNTRY = 'UNITED STATES' OR POD_COUNTRY = 'CANADA') ) OR ((DESTINATION_COUNTRY_CODE = 'US' OR DESTINATION_COUNTRY_CODE = 'CA') AND (POD_COUNTRY = 'UNITED STATES' OR POD_COUNTRY = 'CANADA')) AND (POL_COUNTRY <> 'UNITED STATES' AND POL_COUNTRY <> 'CANADA')), 'IMPORT')) AS DIRECTION
Resident tmp1_CCA_F_BOOKING_COMMERCIAL_LINE;
Drop Table tmp1_CCA_F_BOOKING_COMMERCIAL_LINE;
[COMMODITY_GROUPINGS]:
left Join (tmp1.2_CCA_F_BOOKING_COMMERCIAL_LINE)LOAD
TRIM(COMMODITY_CD) AS COMMODITY_CODE,
EXP_KEY_COMMODITY_TXT,
EXP_SUB_COMMODITY_TXT,
EXP_KEY_REEFER_TXT,
IMP_KEY_COMMODITY_TXT,
IMP_SUB_COMMODITY_TXT,
IMP_KEY_REEFER_TXT
FROM [lib://QS_Projects_BA/10_Standard_Data/ALL/10_Shared/10_QVD/COMMODITY_GROUPS_TBL.qvd]
(qvd);
tmp2_CCA_F_BOOKING_COMMERCIAL_LINE:
NoConcatenate LOAD
*
, IF (DIRECTION = 'IMPORT', IF(CARGO_TYPE_CODE = 'RFR', 'REEFER', IF (CARGO_TYPE_CODE = 'OOG', 'OOG', IMP_KEY_COMMODITY_TXT))
, IF (DIRECTION = 'EXPORT', IF(CARGO_TYPE_CODE = 'RFR', 'REEFER', IF (CARGO_TYPE_CODE = 'OOG', 'OOG', EXP_KEY_COMMODITY_TXT)), NULL())) AS KEY_COMMODITY
, IF (DIRECTION = 'IMPORT', IF(CARGO_TYPE_CODE = 'RFR', IMP_KEY_REEFER_TXT, IMP_SUB_COMMODITY_TXT)
, IF (DIRECTION = 'EXPORT', IF(CARGO_TYPE_CODE = 'RFR', EXP_KEY_REEFER_TXT, EXP_SUB_COMMODITY_TXT), NULL())) AS SUB_KEY_COMMODITY
Resident tmp1.2_CCA_F_BOOKING_COMMERCIAL_LINE
WHERE
MATCH(DIRECTION, 'IMPORT', 'EXPORT')
AND
LEG_DATE_TYPE = 'Week at LAP';
Store tmp2_CCA_F_BOOKING_COMMERCIAL_LINE INTO [lib://QS_Projects_BA/10_Standard_Data/ALL/10_Shared/10_QVD/tmp2_CCA_F_BOOKING_COMMERCIAL_LINE.qvd]
(qvd);
Drop table tmp1.2_CCA_F_BOOKING_COMMERCIAL_LINE;
Drop table tmp2_CCA_F_BOOKING_COMMERCIAL_LINE;
Hello all,
I'm investigating on converting rows to column transformation as given below.
I have referred serval blog on row to column conversion couldn't manage to get any good solution yet .
Please let me know how can we achieve below output as shown .
I am bringing data using two views in the data load script like below. When I run the views in oracle directly each view is taking around 1 minute. But the data load using Qlik is taking around 4-5 minutes. I am not bringing a lot of data in to the memory also ( around 3 hundred thousand)
TABLE A:
VIEW 1 :Select * from A,B,C,D where (A.ID=B.ID AND B.KEY=C.KEY AND D.ID1 =C.ID1)
TABLE B:
VIEW 2
Hi all, Please assist here.
how can I join the Two Pivot tables to a Long Sales Table. first Pivot Table where Fin-Year is Equal to 2016 and 2nd pivot table where Fin-Year is Equal to 2017 but while loading both Pivot table from excel files and not as Inline. the only common field is "Pack Size".
2016 Financial Year (1 Jul 2015 to 30 Jun 2016)
Brand | 1L | 2L | 500ml | 250ml | |
ColaMax | ZAR 13.50 | ZAR 26.00 | ZAR 8.50 | ZAR 6.00 | |
FizzyPeach | ZAR 13.50 | ZAR 26.00 | ZAR 8.50 | ZAR 6.00 | |
GrapeSupreme | ZAR 13.50 | ZAR 26.00 | ZAR 8.50 | ZAR 6.00 | |
JuicyApple | ZAR 13.50 | ZAR 26.00 | ZAR 8.50 | ZAR 6.00 | |
PinePop | ZAR 13.50 | ZAR 26.00 | ZAR 8.50 | ZAR 6.00 | |
SuperMax | ZAR 13.50 | ZAR 26.00 | ZAR 8.50 | ZAR 6.00 | |
VeryBerry | ZAR 13.50 | ZAR 26.00 | ZAR 8.50 | ZAR 6.00 | |
XtremeOrange | ZAR 18.50 | ZAR 26.00 | ZAR 13.00 | ZAR 9.00 |
CrossTable ("Pack Size",Price)
LOAD
Brand,
"1L",
"2L",
"500ml",
"250ml"
FROM [lib://DataFiles/Tables.xlsx]
(ooxml, embedded labels, table is [Table 1]);
2017 Financial Year (1 Jul 2016 to 30 Jun 2017)
Brand | 1L | 2L | 500ml | 250ml |
ColaMax | ZAR 15.00 | ZAR 28.00 | ZAR 11.00 | ZAR 8.00 |
FizzyPeach | ZAR 15.00 | ZAR 28.00 | ZAR 11.00 | ZAR 8.00 |
GrapeSupreme | ZAR 15.00 | ZAR 28.00 | ZAR 11.00 | ZAR 8.00 |
JuicyApple | ZAR 15.00 | ZAR 28.00 | ZAR 11.00 | ZAR 8.00 |
PinePop | ZAR 15.00 | ZAR 28.00 | ZAR 11.00 | ZAR 8.00 |
SuperMax | ZAR 15.00 | ZAR 28.00 | ZAR 11.00 | ZAR 8.00 |
VeryBerry | ZAR 15.00 | ZAR 28.00 | ZAR 11.00 | ZAR 8.00 |
XtremeOrange | ZAR 22.00 | ZAR 40.00 | ZAR 17.00 | ZAR 11.00 |
CrossTable ("Pack Size",Price)
LOAD
Brand,
"1L",
"2L",
"500ml",
"250ml"
FROM [lib://DataFiles/Tables.xlsx]
(ooxml, embedded labels, table is [Table 2]);
Sales:
LOAD
FinYear,
"Year",
"Month",
Brand,
"Pack Size",
Region,
Channel,
"Sales Qty"
FROM [lib://DataFiles/Sales 2017 and 2016.xls]
(biff, embedded labels, table is Sheet1$);
hi everyone
I flagged some values based on this formula so i'm trying to create a filter so that user can filter the flag , so i'm not sure of how do i create a filter from calculated value in frontend.
formula is : if(sum( [Unit Retail Price]-[PO Unit Cost])/sum( [Unit Retail Price]) <0.35 , ARGB(125,235, 51, 30),if(sum( [Unit Retail Price]-[PO Unit Cost])/sum( [Unit Retail Price]) >.65,argb(125,235, 51, 30)))
i just want to create a filter in front end when user click on it it show values filtered by formula above
i've attached pic of flags below
thank you in advance.
Hi,
What exactly is backed-up when backing up NPrinting?
I have read the backup guide: https://help.qlik.com/en-US/nprinting/April2019/Content/NPrinting/DeployingQVNprinting/Backing-up-Qlik-NPrinting.htm
But I would like to know what is inside the .zip file once the backup is complete.
This information would be useful so we can know how much space is required to store the backup.
Any tips on any folders or files that will be particularly large in the backup would be good to know.
We largely use NewsStand and Email delivery mechanisms of NPrinting.
MVP
22789MVP
8647Employee
8635MVP
8190MVP & Luminary
7987Employee
6506MVP & Luminary
5332MVP
5172MVP & Luminary
4332Employee
4107Hear from the Qlik Community team about the latest platform enhancements and other topics.
Important and useful support information about end-of-product support, new service releases, and general support topics.
Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.
We are bringing together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2.
Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense.
This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.
Virtual Meetups are now a possibility! With the impact of COVID-19, the Qlik Meetup network has expanded its support to include the ability to host your next Meetup online. Email QlikMeetups@qlik.com to get your virtual Meetup started!’
Qlik can help you manage your supply chain risks during COVID‑19.The nonprofit organization, Direct Relief, uses Qlik’s Supply Chain solution to scale its delivery of medical supplies worldwide.