TABULAR - Missing Row in report

paulcalvet — Fri, 15 Nov 2024 21:01:03 GMT

Hello

We have a problem with tabular.

In Qlik application we have a table with this data :

CLIENT	SALES Y	SALES Y-1
A	10	8
B		7
C	113

When we create a tabular export on this table, we obtain

CLIENT	SALES Y	SALES Y-1
A	10	8
C	113

The Client B has disappear because he doesn't have value for the current year, and we use a filter on the year to display values.

We opened a case 00159332: Qlik Cloud Tabular Reporting but the support says that it's the normal and it works as expected :

The latest value is not shown because it is excluded by another selection performed by the page. Here we applied all the selections performed by the page and the first level. You can see that only the 2 values of the CLIENT field are active: they are the only ones in green, i.e., the only ones that can be selected.
The tabular reporting can't create a level for the CLIENT B because it is not selectable, it is greyed out in the image because excluded by the previous selections.

@Andrew_Kruger can you help us ? how can we display the same table in Tabular than in Qlik ?

This is work in Nprinting and it is a real regression, because if we want to generate a report for 2023, we have to change the set analysis. In Nprinting, we just have to change the filter in the excel file.

Regards,

Re: TABULAR - Missing Row in report

paulcalvet — Tue, 21 May 2024 15:52:31 GMT

Hello,

We try to change the formula.

The filter in the report don't have time selection and set analysis allow us to display the good value.

In this case, a YTD analysis works (ex. 2023-01 to 2023-04 compared to 2024-01 to 2024-04)

But if we want to export all data, all 2023 and the first month of 2024, some values are missing...

topic TABULAR - Missing Row in report in Reporting Service & Alerting

TABULAR - Missing Row in report

Re: TABULAR - Missing Row in report