Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
VaishnaviMogal2345
Partner - Contributor
Partner - Contributor

Check float datatype of field

Hi,

How can I check the datatype of field which is float. in data model viewer, its tag is showing as only $numeric.

thanks.

Labels (2)
3 Replies
Or
MVP
MVP

$numeric is in fact the type of the field - technically, it's a dual which contains the underlying numeric value itself and its text representation.

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/Scripting/number-interpre...

https://community.qlik.com/t5/Official-Support-Articles/How-Are-Data-Types-Stored-In-QlikView-And-Ql...

 

Padma123
Creator
Creator

$numeric-float data and /or numbers

$numeric,$integer-only numbers

 

steeefan
Luminary
Luminary

If(field = floor(field), 'Integer', 'Float')