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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
EWSTG
Contributor
Contributor
‎2022-04-28 12:11 PM

Ignore Selection

All the answer on how to ignore selection using {1} and so are for measurement and using SUM, AVG, COUNT, etc. I am looking for ignoring a selection in a table dimention that is not a calculated field. I want to show all the data in a field that is a text field regradless of the selection. 

What is the right way.?

thanks

EW

Labels (1)
Labels
486 Views
1 Reply
vinieme12
Champion III
Champion III
‎2022-04-28 12:53 PM

Change the field to a calculated field and use below expression

=Aggr(Only{1}FieldName),FieldName)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
472 Views