Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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
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.
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.
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
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
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?
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";
14x Olympic Medalist. 16x World Record Breaker. And Qlik Connect Keynote Speaker. Save $500 until Dec. 31, 2024
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row.
Qlik Reporting Service received a significant upgrade with several new features!
Join us on Jan. 15 for expert guidance on thriving post-AI with After AI: Reinventing Data, Insights, and Action Amidst the Noise.
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!