topic Re: Text Object Expression in QlikView

Text Object Expression

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

Hi,

I tried the following expression in a text object to highlight the size:

Small <=100

Medium between 100 - 200

Large greater than 200

Expression: =if(max([Size)<=100,'Small',if(max(Size)='>100<=200','Medium','Large'))

The above does not seem to work correctly. Any idea on what should be the correct expression?

Thanks

devarasu07 — Thu, 15 Jun 2017 02:42:24 GMT

Hi,

Try like this,

=if((Size<=100),'Small',

if((Size>100) and (Size<=200),'Medium ',

'Large')

)

antoniotiman — Thu, 15 Jun 2017 03:01:03 GMT

=If(Max(Size) <= 100,'Small',If(Max(Size) <= 200,'Medium','Large'))

kamal_sanguri — Thu, 15 Jun 2017 04:46:28 GMT

You have provided conditions incorrectly,

Incorrect:

=if(max([Size)<=100,'Small',if(max(Size)='>100<=200','Medium','Large'))

the condition highlighted in Red is incorrect, it should be if(max(Size)>100 and max(Size)<=200)

Other conditions are OK.

Correct One:

=if(max(Size)<=100,'Small',if(max(Size)>100 and max(Size)<=200,'Medium','Large'))

kamal_sanguri — Thu, 15 Jun 2017 04:50:32 GMT

Since you have handled values less than 100 in first condition, the max(Size)>100 is actually not required in your second condition for Medium.

=if(max(Size)<=100,'Small',if(max(Size)>100 and max(Size)<=200,'Medium','Large'))

So, this is enough

=if(max(Size)<=100,'Small',if(max(Size)<=200,'Medium','Large'))

Sergey_Shuklin — Thu, 15 Jun 2017 05:19:05 GMT

Hello, Shamit!

What is the size? Is it some field or a text object parameter like "Width"/"Height"?

Or you want to color text object depend on calculation? If so, then you must use color defining condition.

Kushal_Chawda — Thu, 15 Jun 2017 07:05:34 GMT

=If(Max(Size) <= 100,'Small',If(Max(Size) > 200,'Large','Medium'))

shamitshah — Fri, 16 Jun 2017 04:16:25 GMT

Thanks , that worked out.

Shamit