topic Expression Help in QlikView

Expression Help

Sunil_Kenth — Thu, 29 Sep 2011 11:07:57 GMT

I am trying to colour the background of a cell in a straight table if the dimension equals a certain value.

I have clicked on + sign next to my demonsion name and then double clicked on Background and entered the following expression:

=if(((Brand)"Mazda"), LightRed)

I get the message saying error in expression.

Can you tell me what i'm doing wrong?

Thanks,

Sunil

Expression Help

IAMDV — Thu, 29 Sep 2011 11:16:52 GMT

This should work...

=if(Brand = 'Mazda', LightRed())

Thanks,

Expression Help

Sunil_Kenth — Thu, 29 Sep 2011 11:17:29 GMT

Got it working using the following expression:

=if( Brand = 'Mazda', green(),
if( Brand = 'Ford', green(),
if( Brand = 'BMW', green(),white()
)))

Expression Help

its_anandrjs — Thu, 29 Sep 2011 11:18:13 GMT

Hi,

You need to write

=IF( Brand = 'Mazda', Lightred())

Rgds

Anand

Expression Help

its_anandrjs — Thu, 29 Sep 2011 11:20:02 GMT

Hi,

Use this

=If( Brand = 'Mazda' or Brand = 'Ford' or Brand = 'BMW', green(),white())

Rgds

Anand

Expression Help

SunilChauhan — Thu, 29 Sep 2011 11:20:03 GMT

if(((Brand)="Mazda"), Rgb(255,102,102))

Re: Expression Help

IAMDV — Thu, 29 Sep 2011 11:25:16 GMT

Sunil - If you have massive dataset, then you need to Load the Colors within the Script instead of using the IF - conditional statement. This will improve the performance compared to using the IF statements.

I hope this helps!

Cheers - DV

Re: Expression Help

Sunil_Kenth — Thu, 29 Sep 2011 11:27:17 GMT

Thanks DV.

The data set isn’t that huge so it’s performance is fine.

Thanks,

Sunil

Expression Help

Thu, 29 Sep 2011 11:36:50 GMT

As a matter of performance, try avoid using 'if' and use pick/match instead:

pick(match(Brand, 'Mazda'), lightred())

Regards,

Gordon