Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prabunakil
Contributor III
Contributor III

if statement in Straight table

Hi i write the expression in the straight table:

if([Total Points Available]<=199, 'Silver') and

if([Total Points Available]>=1000, 'Topaz') and

if([Total Points Available]=200 and [Total Points Available]<599, 'Gold')

the value return is = -

which is wrong.

please advise the script which part is wrong.

3 Replies
andrey_krylov
Specialist
Specialist

if([Total Points Available]<=199, 'Silver',

if([Total Points Available]<599, 'Gold',

if([Total Points Available]>=1000, 'Topaz')))

Frank_Hartmann
Master II
Master II

try this:

if([Total Points Available]<=199, 'Silver',

if([Total Points Available]>=1000, 'Topaz',

if([Total Points Available]=200 and [Total Points Available]<599, 'Gold')))

hope this helps!

prabunakil
Contributor III
Contributor III
Author

Hi Franky

 

First two if is working, 

but third if is throw out error '-'.