How to export the filter selections (and not the data) into excel from Qlikview

[lmcarter]

Hi Qlik community 🙂

I want to export the values of the filters selected within a dashboard into excel (.csv format)

Example:

I have a dataset with the following variables

• Gender
• Age
• Country 
• City
• Language

A user applies the following filters to the dashboard: Gender (Male), Age (25-35), country (South Africa)

I want to create a button that exports an excel file that looks like this (Filters that have not been applied still need to appear in the file with a blank value):

Gender	Age	Country	City	Language
Male	25-35	South Africa

[jaibau1993 · Accepted solution]

Hi!

What a funny problem! It can easily done with macros but I thought that a straight table is quite more understandable... or so I hope, expresions got complicated! Please, find the attached file.

Bests,

Jaime

[lmcarter]

Thanks for such a speedy response! 

It works perfectly, thank you