Hi Qlik-Experts,

I want to generate a grid chart using two dimensions and calculate the relative fraction but aggregated by one of the dimension.

Unforturnately I am struggling right now.

Attached screenshot shows, that the sum per each row seems to work.

The overall "aggregated sum" is also correct (2.540.234), but for my understanding it would need to be shown in each row of the last column.

Could you please help to push me in the right direction?

Thanks in advande

Hello everyone,

I have two similar tables that I want to do a full outer join on to become one. I want to include all fields from both tables where there is a match and create a column that explains whether the row is on the left table, both tables or right table. I've looked this up both the other questions in the community don't work for me. Example data below.

Server Warehouse:

Database Warehouse:

Expected Outcome:

We have a theme in our QlikSense on-premises Windows system. I can download it as a zip file via QMC -> Extension -> Export.

It was created by a former colleague who is no longer with the company.

QUESTION: I would like to learn more about how to edit this file and understand its contents. Thanks in advance

PS
The zip file contains following files:

Please have a look at the attached qvw. My goal is to make text bold when a condition is met.
The problem is that in more recent years when I add a new dimension value the text is not formatted.
I'm sure it has something to do with the year the dimension_value first exists, but I don't know how to fix this.
Any suggestions?
The attached file is from an older Qlikview version, but the problem still persists in our current version.

We are using Qlikview May 2021 SR1

version 12.60.20100.0

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!

Hi there 🙂

I have a list of products with list prices and different valid-from dates to this prices. Now I simply want to show only the newest valid-from dates (one per product). Thats it 😄 

Coud you please help me out with the script function. Attached you find the table load.

Thanks a lot!
Pesche