I have many apps in Qlik Sense that use pivot tables. I need to distribute this data in NPrinting, but NPrinting can't handle pivot tables. The only solution I have found is to recreate the pivot tables as straight tables in the app. However, I want users of these apps to still see pivot tables.
My solution is to create a sheet on each app called "RawData" that would include straight table versions of the pivot tables in the app. However, I would like to hide all sheets named "RawData" from end users to keep things clean.
My first question: is this a reasonable solution, or is there a simpler method to getting pivot tables into NPrinting?
If this solution is reasonable, how do I create page level permissions?