I am new to Qlik and i am testing for section access. In my sheet (for testing purposes), I want to display the email of the user who is looking at the sheet. Basically, i want to show the users email id (which is defined in section access) on a text&image object in the qlik sheet.

Hi All, I have DB2 data source and we implemented Qlik replicate. Now DB team is asking for enable audit trail they want to know is any impact will come on Qlik replicate.

Hello,

I noticed a strange behavior according to I use a dimension or a level.

In my table, I use 2 levels and a dimension + several measures contained in a Qlik table. When I want to replace the dimension by a level, all records with 0 for current year are removed, whereas they have amounts for previous year. This is not happened when I use the dimension from the Qlik table.

3 levels:

2 levels + 1 dimension:

Do you have an idea? Is it a bug?

It is really annoying because in another column I need to calculate the difference between two measures. The loop doesn't work if I use 2 levels + 1 dimension.

Update: If I use 3 levels, all rows with 0 as amount for the current year are removed. If I use 2 levels + 1 dimension, some rows with 0 as amount for the current year are removed (I don't find a logical reason why some rows and not others whereas the amounts are 0).

Thanks for your help.

Regards,

Pauline

I am Trying to do CDC Load with ODBC Connection, After selecting the tables when i am trying to run the job it gets failed with below error.

Creating Metadata Manager's utility components failed
Cannot create the source utility component
Failed while preparing stream component 'QAD_PERU'.
Context field(s) are not defined

Attaching the log screenshot.

I'm encountering an error while reloading the application Automation Monitoring app. It is used to work properly, but for the past8 days, i have been getting this error. Could you please help me to understand the issue?

Hello,

I'm using Qlik Sense Enterprise February 2024 with a multi nodes deployment.

I have some disconnection issues after 5 minutes of inactivity, with Firefox only, after opening a QS app passing by the NLB (F5) address.

If I try to connect directly to the address of one of my nodes, I don't have this disconnection issue.

In the AuditActivity_Proxy log, a specific message is visible each time i'm disconnected :

I found some articles about Websocket ping intervall depending on browser, but I really think that it comes more from a parameter at the load balancer level. However, I don't understand why this issue only concerns a particular browser (Firefox) in my case.

Session inactivity timeout is fixed on 30 minutes on each node :

Keep alive timeout is fixed on 10 seconds :

Can you give me some ideas to explore in order to resolve this issue?

Thanks,

Emmanuel

We have the following questions.
1. whether it can be deployed on ubuntu servers to schedule tasks on a regular basis.
2. Is it possible to have an interface to view the execution process of each node for the executed tasks?
3. if there is an error on a node, does it support re-execution from the error node?

Hi,

I'm wondering about a certain scenario.

Say for example, there is a large table that needs to go to an ADLS target using parallel load, and there are 5 parallel segments. 

Is there a possibility of say segment 4 loading before segment 3? Thus resulting in incorrect sequence in ADLS.

Also, are there any best practices regarding loading very large static tables to ADLS? My only current idea is parallel load. Thank you

Regards,

Mohammed

Mohammed

Greetings.

Is it possible to split data on the load coming in from excel in a single column (InputField) into multiple columns using the blank rows between questions as a delimiter?

Current...

Desired...

Hi All,

I have sheet and i want to add images as sheet background. there is no option in sheet properties in my current version in my organization.

I am trying to add using html and css but it's not working properly.

.qv-panel-sheet {
background-image: url("C:\Users\Desktop\1600w--kbTNqEWceg.png");
}

Can you please suggest me how to do this scenario in Qliksense.

Thanks & Regards,

Lakshman