HI Team,

Hope you are doing well. We are upgrading Qlik version from Nov2022 to May2023. After upgrade we have faced issues listed below:

- Font color changed for few KPIs

-Text alignment changed 

-Some charts showing invalid visualization error

- some front end formulas not working. 

Kindly help here at earliest.

How do I create an expression similar to the following?

sum({<Field1={Test1}, [Field2]<>[Field3]>} [Field4])) 

Field4 should be displayed if Field2 and Field3 are not equal. If I create an expression as above, I get an error because <> is not a valid relational operator.

How do I create this correctly?

Hello everyone,

I am trying to distribute a slightly larger table with Tabular Reporting. The table has 31 columns and, depending on the filter, 100-200 thousand data records.

When I try to export it, I get the message in the preview: Max number of objects exceeded in report, error code: REP-400039.

Now the help (https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Reporting-service-specifications-limitations.htm) says something about

Reporting limits for the Qlik add-in for Microsoft Excel
Metric Value
Maximum number of nested levels in a template 5
Maximum number of object tags in a template 200
Maximum number of objects per generated report

A single chart, variable value, level value, or expression value counts as one object.

For Excel tables, 500 generated cells count as one object. If there is an additional remainder of less than 500 cells (for example, several smaller tables containing a total of as many as 499 cells), this does not count as an object.

50,000
Maximum number of generated images in a report 1,000.

Does this mean that I can generate a maximum of 50,000 cells per report (in my case 31 columns x 1612 rows)? Per Excel file, per tab sheet?

Maybe someone can help?

Thanks and regards.

Hi, I have been trying for a couple days to solve the JVM compatibility error.

I get the error when I try to run a job from my imported Talend workspace.

The Java I have installed is of version 11. The compiler is set to 1.8 by default.

I've tried several things:
- Modifying a configuration file of Talend and then adding a Java path as well.

- Getting third party modules to see if it would help resolve the error.

- Reinstalling Java and Talend. I also tried different versions, such as 8 and 22.

I've also tried different solutions that I could find online but none of them seemed to work.

Please help, I can also supply more information if needed.

Kind regards,
J.

Please tell me how to correctly write the formula for the measure of a diagram:

If the variable “filename” contains “AP”, then calculate the ratio of the number of values “1” for the variable “Code by Classifier” to the number of the sum of values “1” and “0” for the variable “Code by Classifier”

I tried two formulas, but both did not work correctly, it seems to me:

1. If(WildMatch(filename, '*АР*'), 

   Count(If([Code by Classifier] = 1, 1, 0)) / Count(If([Code by Classifier] = 1 or [Code by Classifier] = 0, 1, 0))

)

2. Count({< [Code by Classifier] = {"1"}, [filename]={"*АР*"} >} [Code by Classifier]) / Count({< [Code by Classifier] = {"0", "1"}, [filename]={"*АР*"} >} [Code by Classifier])

Hi Team,

I found strange issue in my qlik replicate task, it is regarding record count shown in 'Applied Changes Detail' vs actual records in audit table on target database. The count for few tables is not matching. I am trying to find out reason behind it. I see that it is not dependent on operation, and found that for update/insert both. I don't see any data errors. I have dropped some columns on target database.

Please suggest any possible reasons behind it. 

Hi, I am new to qlik,
I have a pivot table with the dimensions group and subgroup.
the group field is a concatenation of group number and the group name (Num_Group & '- '& Group) and the Subgroup field has the same logic
( (Num_Subgroup & '- '& Subgroup)).
The problem is that I get a null concatenation in the filter panel.
in my dimension I was putting this expression: if(isnull(Group_concat or Group_concat='-'), Group_concat), but it still doesn't remove the null concatenation from the filter...
Can you help me, please.

Hi all,

Please, can anyone explain or send me a link that explain step by step on how to us VB Script Macros to Send email through Outlook In QlikView?

Thanks 

Hi,

I try to concatenate these 2 tables and the fields from the budget one (.xlsx) results in nulls as you can see in the image attatched, where I know there are values. Is there something wrong? 

Many thanks!!!

This is the code: 

HI ,

Please refer the below Snap shot . I need the help to calculate 'Active' Count from the expression field.

Can anybody solve this problem.