Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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.
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.
Sub Dealer Name | Active Count-22 |
Enterprises | 1 |
Vision Limited | Active |
Vision Punpun | 3 |
Electricals | 0 |
Hardware | 2 |
Sale | 6 |
Electronics | 7 |
Ganesh Enterprises | 5 |
I have been trying to create a report using the excel tabular reporting, that creates a new sheet for each Sales Person. To do this I have been trying to use the pages option.
It appears that this works fine for the straight table that is used for the report (i.e. it creates a sheet for each sales person with a straight table on it and the data filtered for each sales person).
However, I need the chart to be shown as a pivot table and if I use the pages option on the pivot table it doesn't seem to work? I end up with a sheet created for each Sales Person (i.e. the tab of the sheet is named correctly for each sales person) but the data within each sheet is not filtered to each Sales Person, all sheets created show the same data on the pivot table which is for the first Sales Person only.
Can someone advise if what I am attempting to do is actually possible?
Thanks.
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!