Excel export

[Anonymous]

In qlikview 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

[rustyfishbones]

Are you using a button to launch the export? or are you right clicking and selecting Send to Excel?

[Anonymous]

Send to excel i am using...Suppose I have Country List box in that India,Pakistan,Bangladesh,Nepal is there .

City Listbox All the cities are there...So if i select India In City India associated value will be displayed. and if i export City to excel I will get all the excluded values along with possible selection. How to get only possible selection exported to excel

[rustyfishbones]

I am not sure of a real simple way, however, you could try this.

Create a List Box with an Expression, so for Country List Box, create an Expression instead of selecting Country

Expression is

AGGR(Country,Country)

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

Try that ans let me know if that works

Regards

Alan