Hello Community,

we are using Microsoft SQL Server as source and PostgreSQL as target where one of table is not having Primary key but includes a LOB column for that we are getting Below Warning

"Column ''yzx" was removed from table definition 'dbo.xyz': the column data type is LOB, and the table has no primary key or unique index"

Any Help or guidance on addressing this issue would be greatly appreciated.

Thank you,

Pranita

(Connector error: closing data chunk stream from client) from File Access Gateway

What seems to be causing this error and how can we resolve it?

Attached here are the logs and content of the json file stated in the connectoragent logs

Qlik Data Gateway  

Hi,
From my understanding from reading the manual, Qlik AutoML currently supports binary classification, multi classification, and regression model algorithms. Deep learning does not seem to be supported.

Is there any use case for Qlik Sense like the one below? Or is it feasible?
1) Users create their own code to build deep learning models.
2) Users prepare training data in Qlik Sense.
3) The user passes the training data from Qlik Sense to the above code to start building the deep learning model.
4) Utilize this model from Qlik Sense.

Thank you

Good afternoon, dear friends.

I'm looking for a way to implement the pre-invoices that will be charged in 2025 in my Dashboard, but show them as of the current date in my charts. For example, it's March 2024. So, in my charts, I can filter the measurements in the analysis set to the current month. However, I created a variable that contains this: Date(Addmonths(today(SCHEDULE_DATE),+1),'MM-YYYY')

Measure: sum({$<[MONTH_YEAR_NUM] = {'$(vCurrentDate)'},[Month_Year_Name]=,Month=>}TOTAL_AMOUNT)

The problem is that when I filter by any month other than the current one, it doesn't allow me to view the measurements in my charts.

Can someone tell me if this is possible or what function to add to my variable?

I attach an example of how I have the history of my information.

Hello,

I am trying to connect Qlik cloud to SharePoint site and fetch data from one of the excel files in the site. I was able to successfully establish the connection  however when I click on "select data" in the connection I am getting the following error message. Has anyone come across this issue?

P.S.: I do have access to the SharePoint site and the file I am trying to fetch data from.

Any help on this is greatly appreciated!

Thank you,

Apoorva

Hi everyone,

I'm working on TOS. I have a data what has about 26 millon rows after tMap process. I want to insert all data to Oracle with tDBOutputBulk and tDBBulkExec. I am running tDBBulkExec after tDBOutputBulk. I can transfer all data to csv file with tDBOutputBulk however tDBBulkExec step isnt' transfer all data to Oracle database. It gets just about 11 million of 26 million.

Do you have any idea?

Thanks a lot

Hello,

We recently upgraded to Qlik Sense on Windows November 2024 Patch 7 and I was excited to try the custom sheet groups feature as we have multiple clients who have asked for this. 

What I'm seeing, however, is that whenever I try to create a new group in a published app using Add To Group > +New Group, I get an Access Denied Error: 5 message. 

The particulars are:

• I'm using a test app that I created containing data and one base sheet. (though I see this same behavior on all of our apps)
• The test app does not have section access. 
• I create a new unpublished custom sheet (My new sheet) and try to add that to the new group as described above and get the Access Denied Error message. 
• I am able to create/publish/delete apps. I am able to create/approve/publish/delete custom/community sheets. I can also create stories and bookmarks. In short, I have full Hub and QMC access. 

And yet neither I, nor anyone else I work with, can add a sheet to a new group in a published app. Do I need to enable a security rule that's specific to creating sheet groups? If so, what would such a rule look like? I already have a rule to allow creation of app objects.

Thanks,

Steve