topic Qlikview export current selections in QlikView

Qlikview export current selections

sagarkharpude — Sat, 16 Nov 2024 21:18:41 GMT

Hi All,

Hope you are doing good!

We just wanted to confirm one thing about Qlikview current selections. Is it possible to export the current selections to CSV file or similar.

I heard that we can achieve it by using Macros. But is there any other work around/solutions apart from Macros.

Have a nice Day!

Thanks,

Sagar Kharpude

Re: Qlikview export current selections

Zhandos_Shotan — Tue, 05 Mar 2019 05:54:54 GMT

I dont see any problem here (or i missunderstood you)

1. Create Current selections Box object,

2. Check Icon options: Copy Data, Send to Excel

Best Regards

Re: Qlikview export current selections

sagarkharpude — Thu, 07 Mar 2019 07:52:11 GMT

Hi Zhandos,

Thanks for the quick reply. Actually I want to export the current selections when we export any chart/table to excel. So Current selections should go along with the data to excel. It's possible with macros. But is there any other way apart from macros.

Thanks,
Sagar Kharpude

Re: Qlikview export current selections

Zhandos_Shotan — Thu, 07 Mar 2019 08:27:20 GMT

Hi!

I think only one way do it without using macros is using

=GetCurrentSelections() function as calculated dimension and place it at first column. For example, you can use pivot table and drag Curr.Selections column at top of table as horizontal dimension (pivotting).

So you get Curr.selections at table header aswell as Exported XLS:

Hope it helps

Re: Qlikview export current selections

Brett_Bleess — Thu, 07 Mar 2019 14:22:44 GMT

Hey guys, may have found a solution for you:

	https://support.qlik.com/articles/000034492

The article does include instructions for both QVServer and Desktop/Developer client. I learned something new as well, did not realize we had the 'text' one, the only two that show in the User Preferences for Desktop/Developer are HTML and BIFF, so you guys forced me to pick up a new item a well! 🙂 Funny how no matter how long you work somewhere, there is always something new lurking! Hopefully this will work for you.

Cheers,
Brett