Hi all,

Follow-up to my earlier thread: https://community.qlik.com/t5/Integration-Extension-APIs/Unknown-chart-errors-for-qlik-date-picker-qlik-variable-input/td-p/2520016 

Since the new analytics/sheet preview mode (https://qlik.dev/changelog/188-new-analytics-sheet/ ), our embedded sheet rendered Dashboard bundle controls (qlik-variable-input, qlik-date-picker) correctly. We embed with the qlik-embed React package (embed-react 2.5.4), ui="analytics/sheet" with the preview flag.

Problem: Variable input controls placed inside the new Tabbed container now show "Unknown chart: qlik-variable-input". Nothing changed in our code or in the app.

• A qlik-variable-input placed directly on the sheet still renders.

• The same object inside the Tabbed container shows "Unknown chart: qlik-variable-input".

• classic/app renders it correctly, but it is not an option for us because it brings the full Sense UI (assets panel, sheet list, toolbar).

Runtime versions served by our tenant: analytics-sheet 0.28.0, analytics-chart 2.6.0, sn-tabbed-container 2.12.0, sense-client 8.784.0.

What we found: in analytics-chart 2.6.0 the top-level chart loader handles non-sn- types through the sense-client extensions loader. The Tabbed container renders its children through a nested stardust embed instead, and its load function (StardustConfigModel) only resolves types starting with "sn-" and returns "Unknown chart: <name>" for everything else.

Steps to reproduce:

1) Add a Tabbed container to a sheet and put a Variable input (Dashboard bundle) inside one of its tabs.

2) Embed the sheet with qlik-embed, ui="analytics/sheet" and the preview flag.

3) Open the tab with the Variable input.

Expected: the Variable input renders, as it does in the Sense client and when placed directly on the sheet.

Actual: "Unknown chart: qlik-variable-input".

Workaround for now: we are moving the variable inputs out of the container.

Questions:

1) Is this a known regression, and is a fix planned?

2) Until then, is there a supported way to render Dashboard bundle controls inside a Tabbed container in analytics/sheet?

Thanks!

Good Morning all,

this one might be better suited in the API section, but i dont know....I am trying to get the IDs of all QVDs in a given (subfolder) of a space from within my LOAD script. I tried setting up a REST connection (worked) and also giot to see a few QVDs, but these seemed to be only QVDs from my personal folder...Can anyone help 

If this will not work: My ultimate goal is to delete QVDs (using an automation) in a given space based on a list of QVD names that need to be deleted. (I tried that as well, but failed as i need the file IDs for the files i want to delete...which i dont know how to get)

Thanks for any kind of support!

I'd like to load data from an Excel file.  The filename and sheet names change each month.  I can work around the filename, but I can't work around the changing sheet name.

I've tried wildcards.

There are no named ranges in the workbook.

It isn't the first sheet, so I cant simply omit the 'table is' part of the connection.

I can't set up an OLE BD or ODBC connection as I don't have the required privileges. (I believe this would have let me connect to it as a database so I could see the current sheet names).

I don't have access to change the source Excel file.

I'm using Qlik Sense enterprise (on prem).

Does anyone have any suggestions?

I have a table that currently works - it allows the user to select WeekStartShipDate, which is loaded in the load script with a Floor value, filtering the table to just one week:

The variables vStartSixWk and vEndSixWk determine the date range for the 6 Week column. 

vStartSixWk  =(WeekStartShipDate) -42

vEndSixWk  =(WeekStartShipDate)

The 6 Week column is then calculated as follows:

Sum({<WeekEndShipDate={">=$(vStartSixWk)<=$(vEndSixWk)"}>} EquivalentUnits) / 6

The % of 6Wk Total column is calculated as follows:

Num(
Sum({<WeekEndShipDate={">=$(vStartSixWk)<=$(vEndSixWk)"}>} EquivalentUnits) / 6
/
Sum(
TOTAL
Aggr(
Sum({<WeekEndShipDate={">=$(vStartSixWk)<=$(vEndSixWk)"}>} EquivalentUnits) / 6,
ShipTo
)
),
'##0.0%'
)

So, that all works fine until I add another dimension column, such as SalesOrder. Once I do that, the date filter breaks, and the 6 Week expressions return zeroes.

Please advise.

We have two server

Server :: APP447(Windows 2012) has been installed with Qlik Replicate Version Nov 2022 and Enterprise manager Version Nov 2022.
Server :: APP220(Windows 2012) has been installed with Qlik Replicate Version Nov 2022.

As the Nov 2022 Qlik Version is going end of Support by Nov 2024. We are planning to update to Nov 2023.

It is understood Qlik Replicate version Nov2023 doesn't support Windows 2012.

In this case we will have New windows 2019 server ready and install the Qlik Replicate and Enterprise Manager Version Nov 2023 as a fresh installation.

Now Our Concern is, How can we migrate all Jobs/Task/Configuration/persmission and other setting old Environment to new Environment.

What need to be done so that new server reflects same as the old one.

Hi Team,

I am writing up Disaster recovery procedures for our Qlik Replicate servers and have a questions of the cleanest way of restarting the tasks.

So scenario:

1. Backup of server is taken at 1:00
2. Something nasty happens to the server at 6:00 and we have to restore the backup from 1:00

If we restore the sever and let the tasks resume automatically with the server restore; we will duplicate changes captured from 1:00 to 6:00

If we can get the Windows Server back online but the QR service is stopped - is there a clean way to intercept and stop all the QR tasks from resuming when the service is started?

I want to share something I experienced today.

I was dealing with a NPrinting migration, and during the data connection validation, I was getting "A supported version of QlikView Desktop is installed" even though everything was installed.

Initially, I got the license check mark to be red as well; then I successfully leased a license, and it went away, leaving me with the supported version failure.

I've tried installing greater versions of QlikView Desktop and got the same results (even knowing it needs to be the same version of QVS).

What I learned is: Reboot the machine after installing QlikView Desktop.

I hope that helps.

Qlik NPrinting QlikView 

I'm trying to use the qrs_app data connection to retrieve information about applications - basically, I want to be able to export a list of streams and apps in those streams to a txt file, so I thought I would start with the qrs_app data connection, but I'm getting the following error:

The underlying connection was closed. Could not establish trust relationship for the SSL/TLS secure channel. The remote certificate is invalid according to the validation procedure.

Please advise. Thank you.