topic Re: Excel export in QlikView https://community.qlik.com/t5/QlikView/Excel-export/m-p/568643#M212001 <HTML><HEAD></HEAD><BODY><P>Send to excel <SPAN class="GINGER_SOFTWARE_mark">i</SPAN> am using<SPAN class="GINGER_SOFTWARE_mark">...</SPAN>Suppose I have Country List box in that India<SPAN class="GINGER_SOFTWARE_mark">,</SPAN>Pakistan<SPAN class="GINGER_SOFTWARE_mark">,</SPAN>Bangladesh<SPAN class="GINGER_SOFTWARE_mark">,</SPAN>Nepal is there<SPAN class="GINGER_SOFTWARE_mark"> .</SPAN></P><P>City Listbox All the cities are there<SPAN class="GINGER_SOFTWARE_mark">...</SPAN>So if <SPAN class="GINGER_SOFTWARE_mark">i</SPAN> select India In City India associated value will be displayed. <SPAN class="GINGER_SOFTWARE_mark">and</SPAN> if <SPAN class="GINGER_SOFTWARE_mark">i</SPAN> export City to excel I will get all the excluded values along with possible selection. How to get only possible selection exported to excel</P></BODY></HTML> Sat, 25 Jan 2014 13:45:47 GMT Anonymous 2014-01-25T13:45:47Z Excel export https://community.qlik.com/t5/QlikView/Excel-export/m-p/568641#M211999 <HTML><HEAD></HEAD><BODY><P>In <SPAN class="GINGER_SOFTWARE_mark">qlikview</SPAN> how to export only selected values in excel because whenever we export to excel excluded values also get exported..Is there any way to do this</P></BODY></HTML> Sat, 25 Jan 2014 13:34:08 GMT https://community.qlik.com/t5/QlikView/Excel-export/m-p/568641#M211999 Anonymous 2014-01-25T13:34:08Z Re: Excel export https://community.qlik.com/t5/QlikView/Excel-export/m-p/568642#M212000 <HTML><HEAD></HEAD><BODY><P>Are you using a button to launch the export? or are you right clicking and selecting Send to Excel?</P></BODY></HTML> Sat, 25 Jan 2014 13:38:09 GMT https://community.qlik.com/t5/QlikView/Excel-export/m-p/568642#M212000 rustyfishbones 2014-01-25T13:38:09Z Re: Excel export https://community.qlik.com/t5/QlikView/Excel-export/m-p/568643#M212001 <HTML><HEAD></HEAD><BODY><P>Send to excel <SPAN class="GINGER_SOFTWARE_mark">i</SPAN> am using<SPAN class="GINGER_SOFTWARE_mark">...</SPAN>Suppose I have Country List box in that India<SPAN class="GINGER_SOFTWARE_mark">,</SPAN>Pakistan<SPAN class="GINGER_SOFTWARE_mark">,</SPAN>Bangladesh<SPAN class="GINGER_SOFTWARE_mark">,</SPAN>Nepal is there<SPAN class="GINGER_SOFTWARE_mark"> .</SPAN></P><P>City Listbox All the cities are there<SPAN class="GINGER_SOFTWARE_mark">...</SPAN>So if <SPAN class="GINGER_SOFTWARE_mark">i</SPAN> select India In City India associated value will be displayed. <SPAN class="GINGER_SOFTWARE_mark">and</SPAN> if <SPAN class="GINGER_SOFTWARE_mark">i</SPAN> export City to excel I will get all the excluded values along with possible selection. How to get only possible selection exported to excel</P></BODY></HTML> Sat, 25 Jan 2014 13:45:47 GMT https://community.qlik.com/t5/QlikView/Excel-export/m-p/568643#M212001 Anonymous 2014-01-25T13:45:47Z Re: Excel export https://community.qlik.com/t5/QlikView/Excel-export/m-p/568644#M212002 <HTML><HEAD></HEAD><BODY><P>I am not sure of a real simple way, however, you could try this.</P><P></P><P>Create a List Box with an Expression, so for Country List Box, create an Expression instead of selecting Country</P><P></P><P>Expression is</P><P></P><P>AGGR(Country,Country)</P><P></P><P>then if you select a Country you will only see that selection, also if you then export this, you will only export the selected Countries</P><P></P><P>Try that ans let me know if that works</P><P></P><P>Regards</P><P></P><P>Alan</P></BODY></HTML> Sat, 25 Jan 2014 13:51:18 GMT https://community.qlik.com/t5/QlikView/Excel-export/m-p/568644#M212002 rustyfishbones 2014-01-25T13:51:18Z