topic Export to excel but... in QlikView https://community.qlik.com/t5/QlikView/Export-to-excel-but/m-p/465576#M173916 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I got a pivot table with several dimensions and expressions</P><P>Actually this pivot table is heavy i.e. if the user is not filtering any country or all countries are selected I get out of object memory message on the chart</P><P>to overcome this I put a calculation condition that says that the user has to select only one country!!</P><P>For now it's fine</P><P></P><P>now is there a way to export this pivot table with all countries included without actually selecting the countries and be displayed on the sheet?</P><P>ok on the sheet I oblige the user to select only one country but he can export the pivot table with all countries</P><P></P><P>please advise</P></BODY></HTML> Tue, 30 Oct 2012 11:26:33 GMT ali_hijazi 2012-10-30T11:26:33Z Export to excel but... https://community.qlik.com/t5/QlikView/Export-to-excel-but/m-p/465576#M173916 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I got a pivot table with several dimensions and expressions</P><P>Actually this pivot table is heavy i.e. if the user is not filtering any country or all countries are selected I get out of object memory message on the chart</P><P>to overcome this I put a calculation condition that says that the user has to select only one country!!</P><P>For now it's fine</P><P></P><P>now is there a way to export this pivot table with all countries included without actually selecting the countries and be displayed on the sheet?</P><P>ok on the sheet I oblige the user to select only one country but he can export the pivot table with all countries</P><P></P><P>please advise</P></BODY></HTML> Tue, 30 Oct 2012 11:26:33 GMT https://community.qlik.com/t5/QlikView/Export-to-excel-but/m-p/465576#M173916 ali_hijazi 2012-10-30T11:26:33Z