topic Re: report Generated from tabular reporting shows 0 Values for certain ID's but values are presen... in Reporting Service & Alerting

report Generated from tabular reporting shows 0 Values for certain ID's but values are present in the table from the dashboard

Syed_M0 — Wed, 26 Feb 2025 08:24:09 GMT

Hi Guys,

I created a template using excel which fetches an entire table.
while validating the preview file generated from this template with the data from the dashboard, it is seen that for certain ID's the measure column in the report (eg:total waivers) is showing 0. while its respective dashboard would say for that particular ID, total Waivers = $1250.

Can any one explain me why this is occuring. I am filtering the data inside set analysis. for a particular year and payment time.

EG:

Report from preview mode

ID	Country	Waivers
1001	UK	0
1002	USA	0

Same data seen in dashboard:

ID	Country	Waivers
1001	UK	45000
1002	USA	50000

Br,

Syed

Re: report Generated from tabular reporting shows 0 Values for certain ID's but values are presen...

Frank_S — Wed, 26 Feb 2025 18:27:54 GMT

This behavior may indicate the presence of unsupported items or a limitation that has been breached.

Check this link for more but I will highlight a few key points. Ensure that you check them all however.

Qlik Reporting Service specifications and limitations

The following objects are not supported in report templates:

Filter panes
Maps
Charts with these hypercubes types: Tree, Pivot, or Stacked

Using a calculated dimension as a level is not supported

If an app contains one or more fields configured with the Always one selected value property, you need to configure your report filters so that the filters select exactly one value for each of these fields. These report filters need to be applied to the report task.

If you are using a 3rd party visualization, there could be a problem with the visualization itself.

Ideally if you could provide an app and report template that emulates the behavior, we could take a look at it here. You can create such an app with:

1. create> new app

2. in the data load editor, hold down the cntl (control) key the press 00 (two consecutive zeros). This will give you a sample data set to work with and reproduce the issue.

Kind regards...

Re: report Generated from tabular reporting shows 0 Values for certain ID's but values are present in the table from the dashboard

Syed_M0 — Mon, 03 Mar 2025 11:05:49 GMT

Hi,
I fixed it.
One of my calculation was being done using AGGR function. I Played around it by adding additional dimensions to it which fixed the issue

Br,

Syed