Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have an application that reads cdc data from IBM DB2 source and writes to kafka target. There is a calculcated field defined for a table in table settings. We noticed that that calculated field value is null in target beforeRecord={} dataset but does the expected calculation in record={} dataset. Is this expected behaviour. Is there anyway to force it to calculate in beforeRecord too.
To implement CDC task ,we need to add a date filed in context column to retrieve the delta records. Currently there is not date field available in main table so need to take the required date field from lookup table.
Is it possible to pass the lookup date field to the context column?
Type of connection : ODBC CDC
Sample Data for Main Table ,
idh_no | idh_param | idh_details | tdh_type |
123 | abc1 | det1 | typ1 |
124 | abc2 | det2 | typ2 |
125 | abc3 | det3 | typ3 |
126 | abc4 | det4 | typ4 |
Sample Data for Look up table,
inv_no | inv_date | prd_name | |
123 | 4/30/2024 | prd1 | |
124 | 5/1/2024 | prd2 | |
125 | 5/2/2024 | prd3 | |
126 | 5/3/2024 | prd4 |
We need to pass the inv_date from the lookup table to to the context column to retrieve the delta in ODBC with CDC task
join condition is
main.idh_no = lookup.inv_no
Hi,
My requirement is for a dashboard to run on 1st and 2nd Friday each month. Below is how I had it setup.
Custom increment: 0 0 1 0
Custom filter: * * 1,2 5 * * * *
After I created the task, noticed next execution field is blank and doubted if it would run. As expected, when I checked today (5/3 - first Friday) it did not. Where did I go wrong?
Appreciate any suggestions. Thanks!
Need Help. I would like to make a Bar chart like above. For Machine X, I want to show Jan (50 pcs) and Feb (40 pcs) production quantity separately. Then third bar will show sum of two months (90 pcs). Anyone can help me please? Thanks.
Hi everybody,
I have an excel made in this way:
shop | owner | Is the shop in city center? | note | Shop size | note1 | Are there enough sale item | note2 |
a | john | Y | Near the church | Small | Little shop with lot of other activities near there | Yes | NA |
b | james | Y | In the main Square | Medium | The shop is the biggeest in the Square | No | They sold everything on weekend |
c | Juliette | N | In a very crowded neighborhood | Large | Inside shopping center | Yes | NA |
the note refer to question "Is the shop in city center?"; note1 refer to "Shop Size", and note2 refer to "Are there enough sale item".
I want to obtain a table like that:
shop | owner | question | answer | note |
a | john | Is the shop in city center? | Y | Near the church |
b | james | Is the shop in city center? | Y | In the main Square |
c | Juliette | Is the shop in city center? | N | In a very crowded neighborhood |
a | john | Shop size | Small | Little shop with lot of other activities near there |
b | james | Shop size | Medium | The shop is the biggeest in the Square |
c | Juliette | Shop size | Large | Inside shopping center |
a | john | Are there enough sale item | Yes | NA |
b | james | Are there enough sale item | No | They sold everything on weekend |
c | Juliette | Are there enough sale item | Yes | NA |
Is possible to obtain it without using ALIAS? Maybe using the cell of excel like "A";"B";"C"....
Thank you so much
BYE 🙂
Qlik Compose for Data Warehouses
Hi I am trying to export the project using Compose CLI and I am getting below error.
Command ComposeCliexport_csv failed SYS-E-HTTPFAIL, Session expired.
This is what I am trying
<path where we have installed the compose software>\ComposeCli.exe export_csv --project <project name> --outfolder C:\EXPORT\ABC
Any help on this topic is greatly appreciated.
I have an AG with 3 nodes and 3 different subnets which means the listener has 3 ip's. Per Qlik instructions, you have to specify an ip when connecting to the listener. Since we have 3 ip's, how do we handle a failover to one of the other nodes if we are only specifying one ip in the endpoint connection?
I followed instructions detailed here
Hi, All,
Our NPrinting DEV server (May 2023 IR) has been running well for months. But yesterday I noticed its engine status is offline. Meanwhile, a task hangs (with 'Running' status) there forever.
So far I have checked/done the following but they do not help:
. All NPrintng services are running.
. I have rebooted the server a couple of times.
I found this error in engine.log and scheduler.log: RabbitMq service is not connected - trying again in 60 seconds. ERROR: RabbitMQ.Client.Exceptions.BrokerUnreachableException: None of the specified endpoints were reachable
I followed the instruction in this link (https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/Troubleshooting/Qlik-NPrinting-Messaging-Service-startup-connection-problems.htm) and executed ''rabbitmqctl.bat status' command, it gave me error saying I need to run 'rabbitmqctl start_app' command first. So I ran that 'rabbitmqctl start_app' command. It only displayed a message 'Starting node xxxxx...' and then returned. But the problem remains.
I have submitted Qlik support ticket. Just want to seek advice from the community while I am waiting.
Thanks
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.
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!