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 Experts

Please help with real-world experience using QVX files kindly share some insights into their use cases?

Additionally, if there are any relevant documentation or resources available on this topic, I'd greatly appreciate it if you could share them as well.

Thank you!

I have a Pivot Table with two dimensions the PLACE in the Y Axis and The Week on the X Axis.

The Function is like Sum ({<Place, Week>} Weight)

I colored the background of each Name of The dimension PLACE with a different color and with the Function:

Pick(Match(Place,'A','B','C'), red, green, yellow )

Why when i Select a value in the pivottable the colors disappear?

Hi all,

i'm trying to login to qlik using a JWT token but when i try to post to https://horsadev.eu.qlikcloud.com/login/jwt-session with the the web integration id and the bearer token i get the following error.

the token is made up like this:

user details: name sub and email are the exactly like the console.

any idea of what can go wrong here?

thanks,

Loris

Bonjour,

Où trouve-ton la tâche planifiée de chargement de données de qlikview (version 12) ainsi que les informations associée horaire, fréquence déclenchement ... comme on le voit sur QMC de Qliksense ? 

En vérifiant l'ensemble des tâches planifiées sous Windows, nous ne voyons pas de tâche planifiée portant de nom significative qui pourrait être associée à l'application qlikview. 

On ne trouve pas assez de détail dans la documentation Qlikview.

Merci par avance. 

Hi, I would like to calculate rolling sum like in the table below. Data should be grouped by column "Family". For each quarter I want to take a look at current quarter and 2 quarters backwards. Any idea how to achieve this in script editor? I am not interested in set analysis using rangesum - above combination. Column "Quarter" comes from fiscal master calendar.

Thank you.

I have dataset like this

and I want a new field ItemGroup where is the group item of each line that it belongs too. 

So I basically want to add the itemcode (example Gitem1) of the LineType "group" to new field ItemGroup

to all the fields with the same TranID as long as LineType "endgroup" is reached. After that the next group's itemCode is added to the next lines to ItemGroup -field