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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
DaveStraw
Contributor II
Contributor II

Showing criteria in export

Is there a way to show the criteria and filters that were used to generate the export. I believe this was something that was available at some point. 

I have tried to use =GetCurrentSelections() which does spell out the criteria but this is not present (as far as I can see) when exporting.

Thanks in advance! 

Labels (1)
1 Solution

Accepted Solutions
JandreKillianRIC
Partner Ambassador
Partner Ambassador

Hi @DaveStraw 

I assume this is a export to excel. 

If this is a Image - You can add it in the Subtitle 

JandreKillianRIC_1-1737639256615.png

 

JandreKillianRIC_0-1737638819981.pngJandreKillianRIC_1-1737638830464.png

 

If this is excel (Not a pretty example but it works) 

I would add a measure and move it to the front (First Column) 

 

=IF(RowNo(Total) = 1, 
     GetCurrentSelections(), '')

 

JandreKillianRIC_2-1737638978160.png

Excel Result 

JandreKillianRIC_3-1737639001995.png

Or just add it as a Measure, at the end with a calculation of =' ' (Equal to a space) and in the lable expression do this 

='Report Selections: '&IF(Len(GetCurrentSelections()) = 0, 'None', GetCurrentSelections())

The result would look like this 

JandreKillianRIC_0-1737639228314.png

 

Excel 

JandreKillianRIC_2-1737639262604.png

 

 

Regards - Jandre

 

Mark the solution as accepted that solved your problem and if you found it useful, press the like button! Check out my YouTube Channel | Follow me on LinkedIn

View solution in original post

3 Replies
JandreKillianRIC
Partner Ambassador
Partner Ambassador

Hi @DaveStraw 

I assume this is a export to excel. 

If this is a Image - You can add it in the Subtitle 

JandreKillianRIC_1-1737639256615.png

 

JandreKillianRIC_0-1737638819981.pngJandreKillianRIC_1-1737638830464.png

 

If this is excel (Not a pretty example but it works) 

I would add a measure and move it to the front (First Column) 

 

=IF(RowNo(Total) = 1, 
     GetCurrentSelections(), '')

 

JandreKillianRIC_2-1737638978160.png

Excel Result 

JandreKillianRIC_3-1737639001995.png

Or just add it as a Measure, at the end with a calculation of =' ' (Equal to a space) and in the lable expression do this 

='Report Selections: '&IF(Len(GetCurrentSelections()) = 0, 'None', GetCurrentSelections())

The result would look like this 

JandreKillianRIC_0-1737639228314.png

 

Excel 

JandreKillianRIC_2-1737639262604.png

 

 

Regards - Jandre

 

Mark the solution as accepted that solved your problem and if you found it useful, press the like button! Check out my YouTube Channel | Follow me on LinkedIn

DaveStraw
Contributor II
Contributor II
Author

Thanks for the reply, I'll have a look into this and see if I can get it working

DaveStraw
Contributor II
Contributor II
Author

Hi @JandreKillianRIC, I've got it working correctly and exporting for a table but any ideas for a Pivot table?