Hi everyone

Due to security requirements, we need to change the Qlik logo on QlikSense when a user hits an error, such as error 400 or Error 404. We need to remove or change only the logo so that the application is unidentifiable. Could someone point to a direction I can take to accomplish this?

Hello Qlik Experts,

I am trying to create a pivot table in Qlik that shows "Current Sales" and "Previous Month Sales" for each "month year" selected.

However, I'm encountering issues with the accuracy of the figures for the previous month's sales, and I also need the pivot table to dynamically update based on multiple "month year" selections.

Data Structure:

Here is how my data is structured:

Measure for Sum of Amount for Selected Month

sum({<MonthYear,Month,Year,SalesDate = {">=$(=MonthStart(Max(SalesDate)))<=$(=MonthEnd(Max(SalesDate)))"}>} Amount)

Measure for Sum of Amount for Selected Previous Month 

sum({<MonthYear,Month,Year,SalesDate = {">=$(=MonthStart(AddMonths(Max(SalesDate), -1)))<=$(=MonthEnd(AddMonths(Max(SalesDate), -1)))"}>} Amount)

Attached is the QVF. 

Thank you very much for your assistance!

Hi Team,

We're facing some issues with our Replicate installation on Red Hat Linux. We're unable to stop or restart services, and we're also having trouble accessing the Qlik Replicate Console. Any assistance you can provide would be greatly appreciated. When we kill process id after that we are able to start service also access URL what can be cause for this 

Thanks!

Greetings. 

I have the below data:

I would like to create a Table chart that will display the Average Grade by Person Name. In addition, for that person it will also display the average Grade by gender as well as Class.

Output chart with Average values is as per below:

Eg: Overall average grade by gender will consider John's grade as well as all grades that match his gender. So Overall average grade by gender for John = Average(5, 4, 3, 2, 4, 1, 4, 2) = 3.125

Further if user selects a name say John, the output should be as per below:

Thus far, i have not been able to get the correct expression for the last 2 expressions.

Thank you for your time.

We are trying to connect openEdge ProgressDB using ODBC Connection, While Loading the data for  dataset we are getting below error.

Error :

SQL_ERROR  SqlState: HY000 NativeError: -210012 Message: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Column code_value in table PUB.code_mstr has value exceeding its max length or precision. Line: 151 Column: -1

We tried increasing the length of the destination fileds in Qlik, even after that we are getting the same error.

repctl checkpoint "task name" for downstream task (source: log stream task & target : oracle database) is not giving correct timestamp. 

D:\bin>repctl getcheckpoint "TASK_INGCDC_02"

command getcheckpoint response:

{

        "checkpoint":   "checkpoint:V1#33512#1271;638506460899807820;20240120221751514712#0#0#*#0#137"

}

[getcheckpoint command] Succeeded

Regards

Dipankar

Dear Community 🙂

Here the "challenge":

I want to link a table that has three fields: "Product ID", "Supplier No" and "is_DefaultSupplier" as this table shows the Default Supplier every product with the Supplier No.

In the DataModel (attached), I have a table "ProductDim" with the field "Product ID" and a table "Supplier" with "Supplier No". 

How can I link my new table? 🙂 Do I have to go via the LinkTable?

Thanks a lot and greetings from Switzerland!

Pesche