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

[#2]

Hi,

Could you join your application?

[#3]

Not following ??

[sasikanth]

HI

where your are using this one

[ashfaq_haseeb · Accepted solution]

Hi,

Nothing wrong,look at the attachment.

Look at the attached image for setting.

Regards

ASHFAQ

[rsdhavle]

Please elaborate what are you trying exactly. You want to show some green or red arrow images as an indicator?

If yes where are you writing this expression?

[rsdhavle]

Might be in representation of an expression you have not selected Image or something like that as expression looks fine

[#8]

I am writing the expression in the definition section of the expressions in a pivot table chart.

[sasikanth]

then try to post your QVW, nothing wrong in that Exp

Try to post sample file

[#10]

Problem I have I am working on a personal version of Qlikview at the minute. The report can't go live until I have this sorted. I am going to look to see if I can do something with the data as I feel this is where the error lies. Thanks for the help and confirmation my code writing is correct.