Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Carlaf_93
Creator II
Creator II

Pivot selections

Good morning,

i would like to see, on my excel's extraction, the field selected as filters.

For example if i select the value Bill in the field's agents i would like to see it in my extractions.

Like selected values: Bill in Agents...

 

Any ideas?

2 Replies
GaryGiles
Specialist
Specialist

If you are exporting a table or a pivot object, one work around is to add an additional column at the end of the table with an expression of =' '.  Then for the label, use =GetCurrentSelections().  Not a perfect solution, but at least the user can find what selections that were in effect when they exported the data. 

morgankejerhag
Partner - Creator III
Partner - Creator III

Unfortunately, this is not a function of Sense today. There is a paid extension that exports data and can show the selections. If it is important for you it might be worth the cost. https://logiexport.logsys.co.il/

Morgan Kejerhag
Senior Business Intelligence Consultant
Drake Analytics
http://www.drakeanalytics.se