topic Re: Expression in QlikView

Expression

apthansh — Wed, 25 Nov 2020 16:16:04 GMT

if(Region='EMEA','c:/Red.png',

if([Region]='APAC','c:/green.png'))

This expression is not working in a default view in straight table where as it changes the image when I select that particular region.Any idea ?

Thanks much.

Re: Expression

swuehl — Thu, 14 Sep 2017 18:58:43 GMT

Not sure what you are talking about. Could you post a small sample QVW that demonstrates the issue?

Re: Expression

eduardo_dimperio — Thu, 14 Sep 2017 19:00:23 GMT

Hi Ansh,

The problem is the bracket []. Just remove

if(Region='EMEA','c:/Red.png',

if(Region='APAC','c:/green.png'))

Re: Expression

apthansh — Thu, 14 Sep 2017 19:02:48 GMT

tried..but doesnt work

Re: Expression

eduardo_dimperio — Thu, 14 Sep 2017 19:18:12 GMT

What happen? print the message pls

Re: Expression

vishsaggi — Thu, 14 Sep 2017 19:22:46 GMT

Did you change the representation in Expression tab to Image. Like:

= Pick(Match(Region, 'EMEA', 'APAC') , 'c:\Red.png', 'c:\green.png'))

Re: Expression

MarcoWedel — Thu, 14 Sep 2017 20:39:04 GMT

Hi,

you might use this expression in a context where [Region] delivers more than one value, i.e. the default aggregation function "only()" returns a null value. Only when selecting a specific region, one of the conditions is fulfilled and your expression returns an image path.

Re: Expression

apthansh — Fri, 15 Sep 2017 00:26:19 GMT

Thank you.Only() function works but I also wanted to try the below method.Is there anything wrong in the below expression ?just as a back up as I am applying this to API.

=if(GetSelectedCount([Region])='EMEA', 'c:\Red.png','c:\Red.png' AND

IF(GetSelectedCount([Region])='APAC','c:\yellow.png', 'c:\yellow.png' AND

IF (GetSelectedCount(Region])='AMER', 'c:\green.png', 'c:\green.png')))

Thank you much

Re: Expression

vishsaggi — Fri, 15 Sep 2017 00:39:07 GMT

Ansh, GetSelectedCount() returns an integer so may be use GetFieldSelections([Region]).

Re: Expression

MarcoWedel — Fri, 15 Sep 2017 18:55:54 GMT

glad it worked.

Can you please post some sample data and your expected result for this expression, as using AND as a string operator seems a bit odd?

thanks

regards

Marco