If Statement

[#1]

Hi I pretty much new to Qlikview and I am trying to do an If Stetement in a Definition. I am currently trying

=if([Next Period]='Green','qmem://<bundled>/BuiltIn/led_g.png',

         if([Next Period] = 'Red','qmem://<bundled>/BuiltIn/led_r.png',

             'qmem://<bundled>/BuiltIn/led.png'))

But getting nothing can any one show me where I have gone wrong

The only data in the table at the minute is Green or Red

Distressed SQL Developer

[ashfaq_haseeb]

Hi,

Did you try my suggestion.

Regards

ASHFAQ

[sasikanth]

Make sure that

the Field   [Next Period]  have  brackets or with out Brackets like Next Period

Othet than that exp is fine