when you say you want to duplicate the pivot table to excel
do you mean it's only need to display the data or should it be an excel pivot table
where the user can filter the data and change the display?
if the answer is the first option then you can just use the table to export the table as it's displayed in the Qlikview model
if the answer is the second option then you'll need to export the data in the table and use the data as a source for
excel pivot table , in that case you'll need to convert to straight table , usually the same expressions should work both on straight and pivot table in qlikview because the dimensions are the same the only difference is the display
why do you think that the set analysis won't work
can you share a demo data?
Thank you for your reply.
In essence I need to export a straight table to excel. So that the users can make their own selections in Nprinting.
I’ve put my set analysis in the straight table, and it seems to work.
What I’m not 100% sure of – what is the difference, in Nprinting, on working on Levels, or Table.?
Levels takes a field as filter i.e if their is a column A and with values 1,2,3 then level create 3 different table for each values i.e. one table for 1, one table 2 etc ..
Tables if you impose the filter as 1 then it will create 1 table with filter 1 thats it ...this is the difference
Hope this helps you to understand
when you use levels it's basically load the chart data row by row
in the past this was the only method to create an excel pivot table base on data from Qlikview
but now you should use the Table object in nprinting
then create a table in excel that contains all the columns from the table object
you can than use the excel table as source for the pivot table
follow this tutorial