Data disappear without "always fully expanded" option

[posywang]

Hi,

Please review the attached sample QVW. Data disappear when I uncheck "always fully expanded" option in Presentation tab. It is supposed to be a pivot table that offers users expand/collapse function. Please let me know how to fix it. Thanks!

[swuehl · Accepted solution]

Like this?

Note that when you collaps beyond Ind dimension level (so you can collaps only highest dim level Ressource pool), Qlik can't aggregate the values due to your synthetic dimension. And due to presentation option 'suppress zero values', the table will disappear.

[posywang]

Thank you so much! I wish I had posted this question earlier so I can save a couple of hours this afternoon. LOL. Thanks again!!!