Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All.
Having done some research I suspect I cannot get to what I want to achieve here, but this community has been great at helping so here goes.
I want to produce a table which is formatted in a more grouped manner (similar to a Pivot Table maybe), but rather than showing measures in the columns I need to show Dimensions - see example:
Category & Control | In Scope | Implemented | Evidenced | Evidence Description |
Asset Management | ||||
- Asset Ownership | Y | Y | Y | Policy Document |
- Return of Assets | Y | N | ||
- Inventory of Assets | N | |||
People Controls | ||||
- Employee Screening | Y | Y | Y | HR File Records |
In my ideal output rows would be grouped by the Category with the 'Controls' grouped by category (e.g. - Asset Ownership).
Is there functionality in Qlik to do this, or if not are you aware of a extention which might help?
Thanks once again.
Mark.
Hi There, I want to apply filter to exclude those records which contains _RE from the Column1 while loading QVD.
Note: Length of strings are not consistent.
Example I have two columns and ID is the primary key for the table. So, I want to extract only those records which do not have _RE from column 1 while loading the data.
ID , Column1
1, A1234_RE
2, A123678
3, A123787910_RE
4, B12384
Please advice.
I am trying to download data from hubspot
loop is not getting all only first set
every time i need to pass output value to URL using this variable (vRowCount)
i test with postman
Qlik Compose for Data Warehouses
We recently migrated from SQL Server 2014 to SQL Server 2019. For one of the inserts in to the _P table that is labled "Inserting Top Rows into TSTG_Entity_NAme_P for existing objects" that joins to 10 files, it is now unable to complete after 24 hours instead of 3 minutes.
Hi, this has been driving me nuts and wondered if anyone would be able to help.
So I have 2 tables, the first is in a table chart on a sheet, and I need to retrieve 2 fields from the 2nd one using set analysis:
Field 1 | Field 2 | Field 3 | Analysis 1 | Analysis 2 |
1 | A | V | ||
2 | B | W | ||
3 | C | X | ||
4 | D | Y | ||
5 | E | Z |
Field 1 | Field 4 | Field 5 | Field 6 |
1 | AAA | 01/01/2024 | Op1 |
1 | BBB | 01/02/2024 | Op2 |
1 | AAA | 01/03/2024 | Op2 |
2 | BBB | 01/04/2024 | Op1 |
2 | AAA | 01/05/2024 | Op3 |
2 | BBB | 01/06/2024 | Op4 |
In the first table for Analysis 1, I have the following at it works great to retrieve the max date value:
=MAX( {$<[Field 4] = {'AAA'}>} DATE( [Field 5], 'dd-MMM-yyyy'))
In Analysis 2, I need the corresponding Field 6 that matches the Max Date.
My latest attempt was to use this as a nested set analysis without aggregation, but it returns blanks for all records:
ONLY( {$< [Field 5] = {"MAX( {$<[Field 4] = {'AAA'}>} DATE( [Field 5], 'dd-MMM-yyyy'))"}>} [Field 6])
Hi Community,
I'm currently working with Oracle 19c as a source, and I've some tables without primary keys. Need to configure a task for a full load with Change Data Capture (CDC). How should I proceed in managing the absence of primary keys in this scenario? Your guidance on handling this situation would be greatly appreciated.
Regards,
Pranita
Hi Support,
We have recently seen an issue where the Qlik Enterprise Manager service fails to start with the QEM logs indicating the following error:
"[ERROR] REPO-E-FACSQLREP, Failed to connect to SQLite repository 'C:\Program Files\Attunity\Enterprise Manager\data\rtdata.sqlite' "
We were able to resolve the issue by stopping the QEM service and renaming the rtdata.sqlite file to rtdata_old.sqlite, and then renaming the rtdata.new.sqlite file to rtdata.sqlite. After then running the command to upgrade the repository (aemctl.exe repository upgrade), the QEM service was able to run and the console could be accessed.
Previously when we have seen an issue with a data repository file it has been a result of memory or disk space issues on the server. However, in this case, there have been no reported memory/disk space issues on the server. What we'd like to understand is what are the possible reasons the rtdata.sqlite file becomes unreadable/corrupted.
This instance of Enterprise Manager is v2023.11.0.259
Thanks,
Nak
While creating an source end point of SAP Application in Qlik Replicate, I am getting the following error:
Note: I have added sapnwrfc.dll file in environment variables also still I am facing the same issue. Also, same issue appeared for me in QCDI.
Hi,
Need advise.
Source DB from Sybase end point. Target DB is Oracle end point. Total 18 tables to replicate directly. There are 2 tables having CLOB column type. 1 table having 6 CLOB column and another table having 1 CLOB column. Both tables have primary key
We had tried to configure Sybase source end point with 2 parameter:
1) cdcTimeout = 6000
2) executeTimeout = 600
We still hit the same error:
[SOURCE_CAPTURE ]E: RetCode: SQL_ERROR SqlState: HYT00 NativeError: 30149 Message: [SAP][ASE ODBC Driver]The command has timed out. [1022502] (ar_odbc_stmt.c:4693)
[SOURCE_CAPTURE ]E: Failed to position logtransfer [1020401] (sybase_endpoint_capture.c:3352)
[SOURCE_CAPTURE ]E: Error executing source loop [1020401] (streamcomponent.c:1942)
when we are trying for CDC Load for ODBC connection the job is getting failed with below errors.
Error 1:
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
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!