topic Is it possible to export current selections when there are multiple values in a single filter ? in QlikView

Is it possible to export current selections when there are multiple values in a single filter ?

obulreddy — Sat, 16 Nov 2024 19:16:51 GMT

I'm trying to export current selections to an excel which has 29 values selected in the filter for a field. But, it's not showing the actual 29 values selected, instead showing the number of values selected in the export.

Here is my Current Selections screenshot:

When I export to excel, this is how it looks like.

Any ideas are appreciated.

Note: I've already tried the 'On BIFF Exports' under User Preferences and it's not working.

Thanks,

Obul

Re: Is it possible to export current selections when there are multiple values in a single filter ?

alex00321 — Tue, 21 Jan 2020 08:03:40 GMT

Hi you could make a table of your selection and then export. Thanks!

Re: Is it possible to export current selections when there are multiple values in a single filter ?

marcus_sommer — Tue, 21 Jan 2020 14:36:24 GMT

Usually the default-value for this is 12. You could change it within the user-properties in tab general (right-mid area).

An alternatively might be to use getfieldselections() / getcurrentselections() within a textbox and to set there the third / fourth parameter to an appropriate value.

- Marcus

Re: Is it possible to export current selections when there are multiple values in a single filter ?

Brett_Bleess — Thu, 13 Feb 2020 16:39:34 GMT

Just posting Article link that should be helpful in relation to what Marcus discussed, he is spot on!

Current Selections item setting

Regards,
Brett