お世話になっております。

この度、エクステンションの１つであるレイダーチャートについて質問させていただきたく投稿致しました。

Qlik Visualization Bundleに含まれている「Rader Chart」を使用してレイダーチャートを作成しています。

100点×7項目(700点満点)　の点数データをレイダーチャートにした際、

メジャー（点数）の上限を「100」にしたところ、

点数の区切り線？が６つ固定になり、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.

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; 

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)

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)

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.