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,
