One of on our tasks, we periodically get the following error messages:
Unable to get TABLE_DEF for capture table [dbo.TableNAme]
Failure in associating MetadataManager TABLE_DEF with CDC_TABLE_ENTRY"

We are using  SQL Server RDS as an Endpoint - NOT MS-CDC.  

Any help is appreciated!

Hi QV Community, i need help i hope any one can help me.

I have a project to publish a vector image, a map converted to vectors, I have already made the map, it is already connected to the database, on the desktop it works very well, but when I want to see that published image, the report does not show it .

Any idea, Tks.

Hi everyone,
I have this bar chart of the number of requests per quarter year.
There is a clear ascending linear trend that I want to visualize with a trend line. The "naive" built-in trendline from Qlik Sense is biased by the incomplete data of the current, incomplete quarter year as shown in the figure. The reasonable thing to do is to base that trend line on the years before YearStart(Today()).
I guess this is a pretty common thing, but I can't figure out how to implement this. Do you have a hint?

What I tried so far:

• Checking similar topics here and there.
• To calculate the intercept and slope of the regression line, I use Linest_B() and Linest_M().
• As X values, I use numeric value of the quarter year: (Num#(Left([Reception YearQuarter],4))+(Num#(Mid([Reception YearQuarter],7,1))-1)/4))
• As Y values, I use Aggr(Count(RequestID), [Reception YearQuarter]) over the set of Reception Dates from previous years {1<[Reception Date]={"<$(=Date(YearStart(Floor(Today()))))"}>}, or as a complete expression: Aggr(Count({1<[Reception Date]={"<$(=Date(YearStart(Floor(Today()))))"}>} RequestID), [Reception YearQuarter]).
• In a table showing Reception Year-Quarter (both text and numeric) and Count(RequestID), I succeed in correctly calculating Linest_B(Y values, X values) and Linest_M(...) as additional measures, but not Linest_B(...) + Linest_M(...)*X-value
• As a reference line this does not work either.

AggregatedSampleData:
LOAD * INLINE [
Reception Year-Quarter, Count
2021-Q1, 17871
2021-Q2, 17515
2021-Q3, 16443
2021-Q4, 19041
2022-Q1, 19297
2022-Q2, 18020
2022-Q3, 16881
2022-Q4, 19582
2023-Q1, 21232
2023-Q2, 19139
2023-Q3, 18494
2023-Q4, 21002
2024-Q1, 21784
2024-Q2, 1790

];