Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

kindly help out to write the expression on the below condition

HI All,

i am having the column as  below ,

 

Lesser 90Greater 110Amount
500600400
600700800
700800850
800900750

i need to write the expression

if the amount is fall under lesser 90 it should display <90%

if the amount is fall under Greater 110 it should display <110

Below is the expected Result:

Lesser 90Greater 110AmountVariation
500600400   <90%
600700800   >110%
700800850   >110
800900750   <90%

Please help me out how to write the expression for this ,Very urgent requirement !.

10 Replies
vvira1316
Specialist II
Specialist II

I'm not getting what you mean by it is not present. Shouldn't it be doing for all rows of data? May be you can provide larger data set and what is your expected output to understand your need bette. In the 4 line sample data you don't have that scenario so it is difficult to interpret your result expectation.