Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist
Specialist

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

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

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

Highlighted
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!

Highlighted
Contributor III
Contributor III

Hi Franky

 

First two if is working, 

but third if is throw out error '-'.