Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
ghassanaldalati
Contributor III
Contributor III

if statement for tow almost same value

in TextBox I Have tow percentage Value ( A%  &  B%  )

the different between the tow percentage value is very small ( less or more than 0.00001 ) 

now i want to create a logic if statement that show :

if ( {the different between the tow percentage value is very small ( less or more than 0.00001 ) }

    then show me Latter 'X'

     Else Show me Letter 'Y'   )

can I have some help please..

1 Solution

Accepted Solutions
sunny_talwar

May be this:

If(fab(A% - B%) < 0.00001, 'X', 'Y')

View solution in original post

1 Reply
sunny_talwar

May be this:

If(fab(A% - B%) < 0.00001, 'X', 'Y')