Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
1,240 online
Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW

Data Analytics

Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

Data Integration

Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources

Groups

Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.

Qlik Gallery

Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.

Ideation

Participate in Qlik Technical Previews, submit ideas, and review documentation.

Qlik Resources

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

Events

Learn about upcoming Qlik related events, webinars and local meetups.

Blogs

Hear directly from Qlik employees in our ten unique blogs.

About

Get started, find How-To documents, and join general non-product related discussions.

Community Sitemap

Here you will find a list of all the Qlik Community forums.

Recent Discussions

  • No Boards Found
  • forum

    Japan

    エクステンション レイダーチャートの点数区切りについて

    お世話になっております。この度、エクステンションの1つであるレイダーチャートについて質問させていただきたく投稿致しました。 Qlik Visualization Bundleに含まれている「Rader Chart」を使用してレイダーチャートを作成しています。100点×7項目(700点満点) の点数デ... Show More

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

    この度、エクステンションの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段階)にする方法はありますでしょうか?

     

    また、このエクステンションで実現できない場合

    希望の形で作成できる他のエクステンションはありますでしょうか?

     

    ご教授お願い致します。

     

    Show Less
  • forum

    New to Qlik Sense

    Stacked and Clustered Column

    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 hav... Show More

    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.

    anthony-gb_0-1615171990990.png

     

    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.

    Show Less
  • forum

    Qlik Sense SaaS & Multi-Cloud

    How delete 7,000 files inside SaaS DataFiles Folder

    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, ... Show More

    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

    Show Less
  • forum

    New to Qlik Sense

    load script performance

    how do i improve load performance or rather make below script more efficient  MAP_SALES_REP:MAPPING LOAD DISTINCT      TERRITORY_CODE ,     RESPONSIBL... Show More

    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; 

     
    Show Less
  • forum

    New to Qlik Sense

    Transpose Rows to Column transformation

    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'... Show More

    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 .

     

    qlikdoudt.jpg

    Show Less
  • forum

    New to Qlik Sense

    Load time - Qlik Sense vs Database run time

    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. Bu... Show More

    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

     

     

    Show Less
  • forum

    Qlik Sense App Development

    Y Axis Labels in vertical Direction

    In qliksense, I need to show Bar chat Y axis labels in vertical direction . Can someone help me
  • forum

    Qlik Sense Advanced Authoring

    Join Multiple tables

    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 ... Show More

    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)

    Brand1L2L500ml250ml 
    ColaMaxZAR 13.50ZAR 26.00ZAR 8.50ZAR 6.00 
    FizzyPeachZAR 13.50ZAR 26.00ZAR 8.50ZAR 6.00 
    GrapeSupremeZAR 13.50ZAR 26.00ZAR 8.50ZAR 6.00 
    JuicyAppleZAR 13.50ZAR 26.00ZAR 8.50ZAR 6.00 
    PinePopZAR 13.50ZAR 26.00ZAR 8.50ZAR 6.00 
    SuperMaxZAR 13.50ZAR 26.00ZAR 8.50ZAR 6.00 
    VeryBerryZAR 13.50ZAR 26.00ZAR 8.50ZAR 6.00 
    XtremeOrangeZAR 18.50ZAR 26.00ZAR 13.00ZAR 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)

    Brand1L2L500ml250ml
    ColaMaxZAR 15.00ZAR 28.00ZAR 11.00ZAR 8.00
    FizzyPeachZAR 15.00ZAR 28.00ZAR 11.00ZAR 8.00
    GrapeSupremeZAR 15.00ZAR 28.00ZAR 11.00ZAR 8.00
    JuicyAppleZAR 15.00ZAR 28.00ZAR 11.00ZAR 8.00
    PinePopZAR 15.00ZAR 28.00ZAR 11.00ZAR 8.00
    SuperMaxZAR 15.00ZAR 28.00ZAR 11.00ZAR 8.00
    VeryBerryZAR 15.00ZAR 28.00ZAR 11.00ZAR 8.00
    XtremeOrangeZAR 22.00ZAR 40.00ZAR 17.00ZAR 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$);

    Show Less
  • forum

    New to Qlik Sense

    Creating a filter in frontend Qliksense

    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... Show More

    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.

     

     

    Show Less
  • forum

    Qlik NPrinting Discussions

    What exactly is backed-up when backing up NPrinting?

    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... Show More

    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.

    Show Less

Get Started On Community

Start Here Get Started On Community

Top Participants

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements and other topics.

Blogs

Support Updates Blog

Important and useful support information about end-of-product support, new service releases, and general support topics.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.

Groups

Covid 19

We are bringing together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2.

open to all

Groups

QlikView to Qlik Sense

Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense.

open to all

Groups

Qlik Healthcare

This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.

750+ Members

Events

Events & Meetups

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!’

Events

Direct Relief Uses Qlik to Manage Its COVID-19 Supply Chain

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.

Available on Demand