topic AW:Export with selection in QlikView

Export with selection

Mon, 07 Feb 2011 15:04:09 GMT

Hi,

I would like to export the pivot table to excel with selections where we need to show all the selected value (more than 10 values) in a field. But when i export it shows as "10 out of 190" in the selection. Pls let me know how to show all values in the selection.

AW:Export with selection

Mon, 07 Feb 2011 15:37:20 GMT

Hi Rajesh,

look at user preferences --> general tab. There exists ( at least in V10) an input box called "Max Values in Current Selections". Put in the your favorite value.

Regards, Roland

AW:Export with selection

Wed, 09 Feb 2011 04:42:44 GMT

Hi Roland,

Thanks for your response. Is there any alternative to do in QlikView Version 8.5. Pls advice

Regards,

Rajesh

AW:Export with selection

suniljain — Wed, 09 Feb 2011 06:20:26 GMT

you can select required field with the help of macros. and export doc accordingly.

AW:Re: AW:Export with selection

Wed, 09 Feb 2011 11:22:34 GMT

Hi Rajesh,

we are currently using QV9 SR6 for support-purposes and V10 SR1 in "real life". I checked for you 9SR6 --> ok.

Sorry, but 8.5 is a rather old version, I would suggest to migrate to at least 9SR6. If you can't for some reasons, using macros as Sunil told above is a possible way. But as just mentioned, I'd prefer a newer version.