Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
DiegoF
Creator
Creator

Pivot table does't show values of max(Date) until I go deeper in the table

Hi Qlik experts!

I have a Pivot table in which I would like to show the result of a Sum only when it's the max date, I do have the expression and it works fine:

= SUM({$<FECHA = {'$(=max(FECHA))'}>} INCIDENCIA)

Now, in this pivot table I want to show in columns first, the group which it belongs and then, two columns that show the max(date) and the sum of the INCIDENCIA, in rows I have the dimension that gets the value from INCIDENCIA. 

This display will show me the sum correctly but only if I go deeper in the table, meaning by using filters like this:

 

DiegoFraj_0-1658227504451.png

But if I take out any filter, it will show the value to 0%, in measurments I have Ult.Fec. = Max(Date) and Inc. = SUM({$<FECHA = {'$(=max(FECHA))'}>} INCIDENCIA).

DiegoFraj_2-1658227960169.png

 

If it doesn't have any filters it shows like this:

DiegoFraj_1-1658227701233.png

Can somebody explain why it does show the max(date), but I can't see the sum of the max(date) without the filters? All the values are in the same table except Date that has Date in the table and in another table that is a calendar but it shouldn't be a problem IMO, they are relationed only so I can use a calendar to play with the table.

Thanks.

Labels (3)
0 Replies