Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 238,842 members
  • 3,148 online
  • 2,021,584 posts
  • 152,007 Solutions
Announcements
Global Transformation Awards! Applications are now open. Submit Entry

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Replicate

    different schemas with the same table's names in the one replication task

    I have this situation that I have few schemas with the same table names in every schemas and when I am adding these tables names are changed to table_... Show More

    I have this situation that I have few schemas with the same table names in every schemas and when I am adding these tables names are changed to table_name_1 and it is replicating with the same name with "_1" which is different name like in the source. I would like to handle it somehow. In old qlik every table was represanted like schema.table_name and it was not any issue when few schemas had the same table names.

    Show Less
  • forum

    Qlik Replicate

    Filter the number of records in each table

    How can I filter a number of records from each table when replicating a database? For example, the database has 10 thousand tables and each table has ... Show More

    How can I filter a number of records from each table when replicating a database? For example, the database has 10 thousand tables and each table has 1 million records. I would like to replicate only 100 records from each table.

    Show Less
  • forum

    Search the Community

    Qlik download site does not open.

    Hello , We cannot access the Qlik download site from https://qdt.qlik.com/api/downloadsite/auth/saml/login. Moved to a different location? I get the e... Show More

    Hello ,

    We cannot access the Qlik download site from https://qdt.qlik.com/api/downloadsite/auth/saml/login. Moved to a different location? I get the error "403 Forbidden / Microsoft-Azure-Application-Gateway/v2" from this link.

    Thanks

    Show Less
  • forum

    New to Qlik Analytics

    How to do Monthly data with calculations in the table

    Hi All, Requirement: I know how to do calculations  but I need help how to input/handle data like monthly associated with (P Release date) and calcula... Show More

    Hi All,

    Requirement: I know how to do calculations  but I need help how to input/handle data like monthly associated with (P Release date) and calculate monthly data in the table. (do i need any counter or loop or group by with resident load in script) ? 

    I have a huge data (P Release Date) from 2019 to current but here I am using inline table (sample data) to understand the requirements.

    Inline Table (data):

    main:
    load * inline [
    P Release Date, Deleted On, PO Release Date
    12/21/2022, -, 1/18/2023
    12/23/2022, 2/27/2023, -
    12/27/2022, -, -
    1/4/2023, 1/24/2023, -
    1/4/2023, -, 1/17/2023
    1/4/2023, -, 2/28/2023
    1/4/2023, -, 11/30/2023
    1/6/2023, -, 2/9/2023
    1/6/2023, -, 2/16/2024
    1/11/2023, 5/10/2023, -
    1/17/2023, 3/17/2023, -
    1/17/2023, -, 4/11/2023
    2/2/2023, -, 2/7/2023
    2/2/2023, -, 6/21/2023
    2/6/2023, 6/6/2023, -
    2/15/2023, 9/11/2023, -
    2/15/2023, -, 3/14/2024
    3/2/2023, -, 5/3/2023
    3/2/2023, -, 8/16/2023
    3/2/2023, -, 9/22/2023
    3/6/2023, -, 1/2/2024
    3/30/2023, 4/11/2023, -
    3/30/2023, 6/7/2023, -
    3/30/2023, 8/7/2023, -
    3/30/2023, -, 4/20/2023
    3/30/2023, -, 8/29/2023
    ];

    Output Result (in the table):

     

    Calculation 1

    Calculation 2

    Calculation 3

    Calculation 4

    Total of calculation 1,2,3, and 4

    Jan 2023

    0

    1

    1

    0

    2

    Feb 2023

    1

    4

    3

    0

    8

    Mar 2023

    1

    3

    4

    0

    8

     

    Calculated Columns 1, 2. 3, 4, and 5.

    Calculation 1 :

    P Release Date is before start of month

    Deleted On is blank

    PO Release Date is blank

     

    Calculation 2 :

    P Release Date is before start of month

    Deleted On is blank

    PO Release date is after start of month

     

    Calculation 3 :

    P Release Date is before start of month

    Deleted On is after start of month

    PO Release Date is blank

     

    Calculation 4 :

    P Release Date is before start of month

    Deleted On is after start of month

    PO Release Date is after start of month

     

    Calculation 5 :

    Add 1, 2, 3, and 4.

    Thanks in advance.

    Sara.

     

    Show Less
  • forum

    New to Qlik Analytics

    How to find number of days

    Hi, I have a number of  periods and intervals in a generic day-month format. My challenge is how to calculate the number of days an interval intersect... Show More

    Hi,

    I have a number of  periods and intervals in a generic day-month format. My challenge is how to calculate the number of days an interval intersects with a period as per the example table below. 

    I have tried with the DayNumberOfYear() function, which works fine as long as I'm in the same year, i.e. line 1, but when intervals and periods span over 31-dec, as per line 2 & 3, this approach is no longer giving correct results.  

    period_start period_end interval_from interval_to #intervall_days_in_period
    12-dec 20-dec 01-dec 15-dec 3
    05-dec 20-jan 20-dec 10-jan 21
    25-dec 15-feb 20-jan 01-mar 27

     

    Any assistance on how to solve this is highly appreciated. Regards//Peter

    PS. interval_from & interval_to are user input hence solution need to be outside of the script.

     

    Show Less
  • forum

    App Development

    Button Navigation

    I want to use buttons to navigate to a field but its not working , I dont want to use a filter pane I want separate buttons    ive tried using =(if(Wi... Show More

    I want to use buttons to navigate to a field but its not working , I dont want to use a filter pane I want separate buttons 

     

    ive tried using =(if(WildMatch([OWNING_PATCH],'NORTH'),0)) but it wont work 

     

    can anyone help please 

    Show Less
  • forum

    App Development

    Table rows in two colors alternating

    Dear Community, Is there a way to display table rows in two colors, similar to the attached Excel version? (The color is unimportant) I would be very ... Show More

    Dear Community,

    Is there a way to display table rows in two colors, similar to the attached Excel version? (The color is unimportant)

    I would be very grateful for any help.

    Best regards

    Show Less
  • forum

    App Development

    How to create a bookmark that does not affect current selections - is it possibl...

    Here's the scenario: I am creating multiple bookmarks for the same sheet; the only difference for each bookmark is that the layout is changed for a pi... Show More

    Here's the scenario:

    I am creating multiple bookmarks for the same sheet; the only difference for each bookmark is that the layout is changed for a pivot table and the bookmarks are meant to be an easy way for users to get the drill-down order they desire for the pivot table. 

    Because the user may have already selected other filters, I do not want those filters to be cleared when they select a bookmark to change the layout of the pivot table. Is it possible to do this?

    Show Less
  • forum

    GeoAnalytics

    Qlik Sense GeoAnalytics

    Buen día,  alguien podría indicarme como saber la cantidad de búsquedas que me quedan del conector Qlik GeoAnalytic en Qlik Sense 
  • forum

    App Development

    Possible Left Join ?

    Hi All,  So I have two Tables  MKDP & MDTB I need to take all of the rows of field DTNUM in MKDP and get all of the Matching rows in MDTB, and then us... Show More

    Hi All, 

    So I have two Tables 

    MKDP & MDTB

    I need to take all of the rows of field DTNUM in MKDP and get all of the Matching rows in MDTB, and then use the remaining columns from MDTB to build the data set. 

    The below is the code thus far 

    However when used the fields such as PLUMI from MDTB are blank

    Any Help is greatly received

    LIB CONNECT TO [VAR_REV_TRACKER:Snowflake_Sco_Prd];
    
    [MKDP]:
    LOAD
        HVR_ROWID,
        SHSTOVAR_SYNC_TIMESTAMP,
        MANDT,
        DTART,
        MATNR,
        PLWRK,
        PLSCN,
        DTNUM,
        DSDAT,
        BDBKZ,
        SLKZ1,
        SLKZ2,
        SLKZ3,
        SLKZ4,
        SLKZ5,
        SLKZ6,
        SLKZ7,
        SLKZ8,
        VRKZ1,
        VRKZ2,
        VRKZ3,
        MTART,
        MEINS,
        DISST,
        BESKZ,
        SOBSL,
        SOBES,
        WRK02,
        DISMM,
        DISVF,
        DISPO,
        PLDIS,
        EKGRP,
        MTWZT,
        WEBAZ,
        BEAZT,
        FIXTR,
        MFHKZ,
        DISLS,
        LOSVF,
        LOSKZ,
        PERAZ,
        EISBE,
        MINBE,
        HOEBE,
        BSTMI,
        BSTMA,
        BSTFX,
        BSTRF,
        SUM01,
        SUM02,
        SUM03,
        SUM04,
        SUM05,
        NEGBS,
        MSGID,
        MSGAR,
        MSGNR,
        MSGV1,
        MSGV2,
        MSGV3,
        MSGV4,
        DISGR,
        PERIV,
        MRPPP,
        BDARF,
        LFRHY,
        RDPRF,
        BERW1,
        BERW2,
        KZAUS,
        AUSDT,
        NFMAT,
        AUSZ1,
        AUSZ2,
        AUSZ3,
        AUSZ4,
        AUSZ5,
        AUSZ6,
        AUSZ7,
        AUSZ8,
        BEADA,
        NAUKZ,
        SAUFT,
        KZPROMO,
        SHFLG,
        SHZET,
        FABKZ,
        MFXDT,
        BSKFL,
        MAABC,
        CFLAG,
        GRREL,
        RWPRO,
        SHPRO,
        AHDIS,
        BERW4,
        BADON,
        SGT_STATC,
        HANAON,
        GLCHANGETIME,
        ZHDCLTIMESTAMP;
    
    [MDKP]:
    SELECT "HVR_ROWID",
    	"SHSTOVAR_SYNC_TIMESTAMP",
    	"MANDT",
    	"DTART",
    	"MATNR",
    	"PLWRK",
    	"PLSCN",
    	"DTNUM",
    	"DSDAT",
    	"BDBKZ",
    	"SLKZ1",
    	"SLKZ2",
    	"SLKZ3",
    	"SLKZ4",
    	"SLKZ5",
    	"SLKZ6",
    	"SLKZ7",
    	"SLKZ8",
    	"VRKZ1",
    	"VRKZ2",
    	"VRKZ3",
    	"MTART",
    	"MEINS",
    	"DISST",
    	"BESKZ",
    	"SOBSL",
    	"SOBES",
    	"WRK02",
    	"DISMM",
    	"DISVF",
    	"DISPO",
    	"PLDIS",
    	"EKGRP",
    	"MTWZT",
    	"WEBAZ",
    	"BEAZT",
    	"FIXTR",
    	"MFHKZ",
    	"DISLS",
    	"LOSVF",
    	"LOSKZ",
    	"PERAZ",
    	"EISBE",
    	"MINBE",
    	"HOEBE",
    	"BSTMI",
    	"BSTMA",
    	"BSTFX",
    	"BSTRF",
    	"SUM01",
    	"SUM02",
    	"SUM03",
    	"SUM04",
    	"SUM05",
    	"NEGBS",
    	"MSGID",
    	"MSGAR",
    	"MSGNR",
    	"MSGV1",
    	"MSGV2",
    	"MSGV3",
    	"MSGV4",
    	"DISGR",
    	"PERIV",
    	"MRPPP",
    	"BDARF",
    	"LFRHY",
    	"RDPRF",
    	"BERW1",
    	"BERW2",
    	"KZAUS",
    	"AUSDT",
    	"NFMAT",
    	"AUSZ1",
    	"AUSZ2",
    	"AUSZ3",
    	"AUSZ4",
    	"AUSZ5",
    	"AUSZ6",
    	"AUSZ7",
    	"AUSZ8",
    	"BEADA",
    	"NAUKZ",
    	"SAUFT",
    	"KZPROMO",
    	"SHFLG",
    	"SHZET",
    	"FABKZ",
    	"MFXDT",
    	"BSKFL",
    	"MAABC",
    	"CFLAG",
    	"GRREL",
    	"RWPRO",
    	"SHPRO",
    	"AHDIS",
    	"BERW4",
    	"BADON",
    	"SGT_STATC",
    	"HANAON",
    	"GLCHANGETIME",
    	"ZHDCLTIMESTAMP"
    FROM "SCO_PRD"."RAW_SAP"."MDKP"
    
    WHERE "PLWRK" IN ('0600', '0602', '5440', '5442', '4980', '3930', '544E');
    
    
    MDTB:
    
    LIB CONNECT TO [VAR_REV_TRACKER:Snowflake_Sco_Prd];
    
    Left Join ([MDKP])
    LOAD
        HVR_ROWID,
        SHSTOVAR_SYNC_TIMESTAMP,
        MANDT,
        DTNUM,
        DTPOS,
        PLAKZ,
        PLANR,
        DAT00,
        SORT1,
        SORT2,
        DELKZ,
        VSTAT,
        VRFKZ,
        PLUMI,
        MNG01,
        MNG02,
        MNG03,
        DAT01,
        DAT02,
        DAT03,
        PERKZ,
        PRPER,
        WEBAZ,
        FIX01,
        FIX02,
        BAART,
        BESKZ,
        SOBES,
        UMSKZ,
        PLART,
        AUSSL,
        WRK02,
        LGORT,
        DELNR,
        DELPS,
        DELET,
        AUFVR,
        POSVR,
        EINVR,
        UKZ01,
        UMDAT,
        DEL12,
        BAUGR,
        DELVR,
        VERSB,
        OLDSL,
        RDMNG,
        PLAAB,
        TAG00,
        ABEKZ,
        MDFST,
        MDMNG,
        VERID,
        WRK01,
        SERNR,
        REVLV,
        DBSKZ,
        EXTNL,
        ADINF,
        RESLO,
        PRIO_URG,
        PRIO_REQ,
        MPNMT,
        GLCHANGETIME,
        ZHDCLTIMESTAMP;
    
    [MDTB]:
    SELECT "HVR_ROWID",
    	"SHSTOVAR_SYNC_TIMESTAMP",
    	"MANDT",
    	"DTNUM",
    	"DTPOS",
    	"PLAKZ",
    	"PLANR",
    	"DAT00",
    	"SORT1",
    	"SORT2",
    	"DELKZ",
    	"VSTAT",
    	"VRFKZ",
    	"PLUMI",
    	"MNG01",
    	"MNG02",
    	"MNG03",
    	"DAT01",
    	"DAT02",
    	"DAT03",
    	"PERKZ",
    	"PRPER",
    	"WEBAZ",
    	"FIX01",
    	"FIX02",
    	"BAART",
    	"BESKZ",
    	"SOBES",
    	"UMSKZ",
    	"PLART",
    	"AUSSL",
    	"WRK02",
    	"LGORT",
    	"DELNR",
    	"DELPS",
    	"DELET",
    	"AUFVR",
    	"POSVR",
    	"EINVR",
    	"UKZ01",
    	"UMDAT",
    	"DEL12",
    	"BAUGR",
    	"DELVR",
    	"VERSB",
    	"OLDSL",
    	"RDMNG",
    	"PLAAB",
    	"TAG00",
    	"ABEKZ",
    	"MDFST",
    	"MDMNG",
    	"VERID",
    	"WRK01",
    	"SERNR",
    	"REVLV",
    	"DBSKZ",
    	"EXTNL",
    	"ADINF",
    	"RESLO",
    	"PRIO_URG",
    	"PRIO_REQ",
    	"MPNMT",
    	"GLCHANGETIME",
    	"ZHDCLTIMESTAMP"
    FROM "SCO_PRD"."RAW_SAP"."MDTB";
    
    
    

     

    Show Less
X
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!