I have a pivot table in Sense; 4 dimensions, 1 measure. Total rows are less than 10k. When I export this table to Excel it is dropping hundreds of rows. I cannot figure this out. I have tried putting the 4th dimension in both columns and rows and no matter what I do it will not export all the rows. I don't think it is related to the number of rows because the numbers of rows is less when I put the 4th dimension in columns.
Does anyone know peculiarities of Qlik Sense pivot tables such that it struggles to export all rows? I can see all the rows I need exported in live table in Qlik.