Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
bbergstrom
Partner - Creator II
Partner - Creator II

Hide Table Column When Visible Text is Blank

Trying to use the Show Column If property but I'm running into an issue.  I'm trying to hide the column only if the text string is empty.  Trying to use the following where the field name is VehUdefName07:

VehUdefName07<>''

This appears to be scanning the entire data set as I filtered on a subset of data where this field is always empty but the column still appears.  Is there a trick to using this feature?

 

Version: Qlik Sense Nov 2019

Labels (4)
2 Replies
Lisa_P
Employee
Employee

Try this:

Show column if
len(VehUdefName07) > 0

bbergstrom
Partner - Creator II
Partner - Creator II
Author

That is hiding the column even if there is data in some of the rows.