topic if statement in Straight table in QlikView

if statement in Straight table

prabunakil — Thu, 08 Nov 2018 09:31:16 GMT

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.

Re: if statement in Straight table

andrey_krylov — Thu, 08 Nov 2018 09:44:54 GMT

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

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

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

Re: if statement in Straight table

Frank_Hartmann — Thu, 08 Nov 2018 09:45:28 GMT

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!

Re: if statement in Straight table

prabunakil — Thu, 15 Nov 2018 09:27:28 GMT

Hi Franky

First two if is working,

but third if is throw out error '-'.