Solved: how to detect that a number has a decimal ? - Qlik Community

mohamed_ahid · ‎2013-11-12

Hi all ,

How can i do that with Qlikview ?

Thx a lot

jonasheisterkam · ‎2013-11-12

if(Mod(Number,1)=0,'Integer','Dec')

jonasheisterkam · ‎2013-11-12

if(Mod(Number,1)=0,'Integer','Dec')

mohamed_ahid · ‎2013-11-12

Thx Jonas

kaushiknsolanki · ‎2013-11-12

Hi,

Try this expression.

if( Index(Field,'.') >0,'YES','NO')

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!