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
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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: 
Not applicable
‎2014-06-11 04:29 PM

RangeMissingCount

Does "=RangeMissingCount(2, '2', 'x', Null() )" evalue to 2 because numbers that are defined as text are still considered numeric?  I would have thought the answer would be 3.

419 Views
0 Likes
1 Reply
Not applicable
‎2014-06-11 04:49 PM
Author

Yes '2' is still interpreted as 2 in QV.  If you create a text object and as your expression do ='60' + 5 the result in the text object will be 65.

316 Views
0 Likes