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: 
tschullo
Creator III
Creator III

Relational Operator in filter not working as expected

I have a simple data set of numbers:

LOAD * Inline [
MyNums
20250826093150
20250826093151
20250826093152
20250826093153
20250826093154
20250826093155
];

When I add a filter in the app for MyNums and do a search within the filter using the string
"<20250826093152" (without the quotes), I expect to get:

20250826093150 and 20250826093151. 

Instead I get nothing.

If I change my filter to "<20250826093153" I get 20250826093150.
If I use "<20250826093154", I get 20250826093150 and 20250826093151.

Does anyone know why this is happenning and how I can fix this? I would prefer a solution that the user can do in the filter search, but if it's the data, let me know.

Labels (2)
1 Solution

Accepted Solutions
tschullo
Creator III
Creator III
Author

this works: =only(MyNums)<20250826093152

View solution in original post

1 Reply
tschullo
Creator III
Creator III
Author

this works: =only(MyNums)<20250826093152