Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Are you using a button to launch the export? or are you right clicking and selecting Send to Excel?
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
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