Hi,

I have Informix as a source and I want to execute a Full Load, but I notice that there is a restriction: 'All transactions should be manually stopped before starting a Full Load task. Transactions started during the Full Load operation will be cached.'

Since I cannot stop transactions on the source database, what are the recommendations?

thanks.

Hi,

I want to use as target in Qlik replicate the Singlestore version 5.7.x with the last version of Qlik Replicate, In the page supported target endpoints says that only supported 8.9.x. Please I need to confirm if 5.7 is suppported or not?

Thanks.

Hi everyone,

Currently, I'm trying to migrate a QlikView document to Qlik Cloud app using the QV2QS Converter Tool (version 1.3.0), but I'm facing some difficulties when automatically creating the prj folder with such tool; it shows the following error:

C:/QlikViewToQlikCloud/DocumentName.qvw","error":"SaveAs failed: (-2147352567, 'Exception occurred.', (None, None, None, 0, None))","elapsed":17.707445599982748}
2026-05-02T00:56:01.887Z ERROR v1.3.0 20260502-005543-272b7fd8 qv2qs prj_autogen_single_fail PRJ auto-generation failed {"qvw":"C:/QlikViewToQlikCloud/DocumentName.qvw","error":"SaveAs failed: (-2147352567, 'Exception occurred.', (None, None, None, 0, None))","error_code":""}

For this reason, I tried creating the files with QlikView Desktop (May 2021 SR2 (12.60.20200.0)). However, when I save certain .qvw documents with a matching empty DocumentName-prj folder next to them, no XML files are generated. The .qvw save itself works (timestamp updates, no errors), but the prj export silently does nothing. Two out of three document I need to convert do not create the files. 

Already ruled out: folder naming, path, permissions, QlikView version, file corruption (Save As reproduces the issue), macros (module empty), User Preferences security and compression settings, extensions, reports, bookmarks, alerts. I also deleted all sheets and emptied the script — prj folder still empty.

Key finding: A brand new blank document with only BINARY LOAD [Path] in the script generates prj files correctly on save. So the data model is fine — the issue might be at the document level in the original (triggers, variables, internal metadata) that silently aborts prj export without affecting the regular save.

The original document has an OnOpen trigger with actions, several other empty triggers, multiple variables, and 13 sheets with standard objects (no extensions).

Has anyone hit this before? Are there known document-level elements (specific trigger actions, variables, properties) that break prj XML generation?

Any help will be appreciated!

Thanks a lot and have a great day!

Check out the article from Women Who Qlik Leader Priscila Paolinelli where she discusses the debate over AI first, data first or process first.  She discusses the importance of data and AI literacy in this conversation among other ideas.

Share your thoughts below or reply to it on Linkedin.

I want to create a table with 250 dimesions and 100 measures so that user selects fields in dim and measure then table should show data

it should not hang or hampers performance 

please help me on this request

I'm trying to do what should be a very simple task for the "Above" function.  I have a table with very few columns.  It would look something like:

DATE                      NBR

xx                            5

xx1                           4

I want to use the Above function to put in a new column with the difference and then calculate the percent of change.

It would be from above 5 minus the current row which is 4  -   5-4=1

Above formula should be something like

Above(NBR)-NBR   (this would be taking the 5 to minus the 4)

If it is 

NBR-Above(NBR)    (this would be taking the 4 and minus the 5)

It will not work either way.  Produces a column with nothing but " - " in it. 

What is the correct process for this?

Hi there, 

I am working on producing a distribution tail showing how many days items take to be delivered across Departments A, B, C and Others. At the moment, the Qlik Pivot Table leaves some cells blank. Instead of blanks or hyphens, I need an expression that carries forward the previous day’s value so the distribution tail remains continuous. Any help would be appreciated, Many thanks. 

Hi All,

I am trying to connect Qlik Sense with Apache Pinot, but pinot does not provide any ODBC driver to create an ODBC connection in Qlik Sense, instead, it provides jdbc driver which is not supported by Enterprise Qlik Sense.

I did some research and found out that we need to use some JDBC-ODBC driver bridge, which is fine, but is there any other way to connect jdbc databases with Qlik Sense ? anything that I am missing ? Any suggestions would be appreciated.

Regards,

Aditya

I have a data load requirement involving two tables:

• Customers (Primary Key - Id)
• Orders  (Primary Key - Id)

My goal is to load all active customers from Customers and their matching active records from Orders. If there are no orders, then those fields should be null in data set (Simple left join condition)

Challenge:

The difficulty I’m facing is correctly handling  two deletion flags while still maintaining an incremental load approach.

Kindly help with below script

IF Len('$(QVD_PATH)') = 0 THEN

Final:
SQL SELECT 
    A.ID,
    A.NAME,
    B.RATE,
    A.IS_CUSTOMER_DELETED,
    B.IS_ORDER_DELETED,
    GREATEST(A.LAST_UPDATE_DATE, B.LAST_UPDATE_DATE) AS LAST_UPDATE_DATE
FROM Customers A
LEFT JOIN Orders B ON A.ID = B.ID AND B.IS_ORDER_DELETED = 0
WHERE A.IS_CUSTOMER_DELETED = 0;

Call StoreAndDrop('Final');

ELSE

Last_Update_Date:
LOAD Timestamp(Max(LAST_UPDATE_DATE)) as Max_LAST_UPDATE_DATE
FROM [$(QVD_PATH)](qvd);

LET vMaxDate = Peek('Max_LAST_UPDATE_DATE', 0, 'Last_Update_Date');

Temp:
SQL SELECT 
    A.ID,
    A.NAME,
    B.RATE,
    A.IS_CUSTOMER_DELETED,
    B.IS_ORDER_DELETED,
    GREATEST(A.LAST_UPDATE_DATE, B.LAST_UPDATE_DATE) AS LAST_UPDATE_DATE
FROM Customers A
LEFT JOIN Orders B ON A.ID = B.ID 
WHERE  GREATEST(A.LAST_UPDATE_DATE, B.LAST_UPDATE_DATE)> '$(vMaxDate)'

Concatenate(Temp)
LOAD * 
FROM [$(QVD_PATH)](qvd) 
where NOT Exists(ID);

Final:
NoConcatenate
LOAD *
RESIDENT Temp
WHERE IS_CUSTOMER_DELETED = 0 AND IS_ORDER_DELETED = 0;

Call StoreAndDrop('Final');

END IF;