topic Re: If Statement in QlikView

If Statement

Tue, 01 Jul 2014 10:31:11 GMT

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

Re: If Statement

Tue, 01 Jul 2014 10:37:45 GMT

Hi,

Could you join your application?

Re: If Statement

Tue, 01 Jul 2014 10:40:07 GMT

Not following ??

Re: If Statement

sasikanth — Tue, 01 Jul 2014 10:41:26 GMT

where your are using this one

Re: If Statement

ashfaq_haseeb — Tue, 01 Jul 2014 10:41:29 GMT

Hi,

Nothing wrong,look at the attachment.

Look at the attached image for setting.

Regards

ASHFAQ

Re: If Statement

rsdhavle — Tue, 01 Jul 2014 10:41:41 GMT

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?

Re: If Statement

rsdhavle — Tue, 01 Jul 2014 10:43:48 GMT

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

Re: If Statement

Tue, 01 Jul 2014 10:44:08 GMT

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

Re: If Statement

sasikanth — Tue, 01 Jul 2014 10:45:46 GMT

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

Try to post sample file

Re: If Statement

Tue, 01 Jul 2014 10:49:58 GMT

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.

Re: If Statement

ashfaq_haseeb — Tue, 01 Jul 2014 10:54:02 GMT

Hi,

Did you try my suggestion.

Regards

ASHFAQ

Re: If Statement

sasikanth — Tue, 01 Jul 2014 10:56:23 GMT

Make sure that

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

Othet than that exp is fine