Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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')