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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
gustavofred
Contributor II
Contributor II

Best way to select everything that is not 0 and not '-'

Best way to select everything that is not 0 and not '-'?

my approach is variable > 0 and variable < 0

what other options to i have to deselect '-', which means null, right?

1 Reply
jyothish8807
Master II
Master II

may be this:

len(trim(Variable)) > 0 and Variable <> 0

Best Regards,
KC