topic Re: Issue when we add some values to the existing expression in QlikView

Issue when we add some values to the existing expression

qlikviewforum — Mon, 27 Feb 2017 07:15:14 GMT

The below expression does not work when I add "+21" to the Column(4), If we remove "+21" from the below expression it is working as expected. I tried using the actual expression and Label name instead of the Column(4) but no luck. Can someone please help on this.

if((Column(4)+21) < 22,'S1',
if(((Column(4)+21) >= 22 AND (Column(4)+21) < 84),'S2',
if(((Column(4)+21) >= 84 AND (Column(4)+21) < 273),'S3',
   if(((Column(4)+21) >= 273 AND (Column(4)+21)<>'NA'),'S4','NA'
     )
    )
   )
)

Re: Issue when we add some values to the existing expression

rahulpawarb — Mon, 27 Feb 2017 07:22:07 GMT

Hello Rikab,

Trust that you are doing well!

If possible, could you please share the application with sample data and desired output? This will help us to provide expected feedback.

Regards!

Rahul

Re: Issue when we add some values to the existing expression

Anil_Babu_Samineni — Mon, 27 Feb 2017 07:22:22 GMT

What are the values with Column(4). Can you try with Num()

if(Num(Column(4))+21 < 22,'S1', if(Num(Column(4))+21 >= 22 and Num(Column(4))+21 < 84),'S2',

if(Num(Column(4))+21 >= 84 and Num(Column(4))+21 < 273),'S3', if(Num(Column(4))+21 >= 273 and Num(Column(4)) + 21 <>'NA'),'S4','NA'))))

Re: Issue when we add some values to the existing expression

jonathandienst — Mon, 27 Feb 2017 07:28:29 GMT

I don't see any syntax errors, but there is one logical error

(Column(4)+21)<>'NA'

This will always be true as you are comparing a number with a string.

It would be easier to spot errors if you removed the unnecessary parentheses.

Re: Issue when we add some values to the existing expression

Peter_Cammaert — Mon, 27 Feb 2017 07:32:49 GMT

Simply add a new expression to your chart, and put the following in the expression edit field:

=Column(4) + 21

Now observe what is happening with the expression results for different row values.

If this doesn't shed some light on what is producing unexpected behavior, then cut your expression into fout different parts and put each one of them in a different expression column. Because of being created as logical expressions, they should all produce either a 0 or a -1 value.

Re: Issue when we add some values to the existing expression

jonathandienst — Mon, 27 Feb 2017 07:44:56 GMT

I think this is what you are looking for:

if(Column(4) + 21 < 22, 'S1',

if(Column(4) + 21 < 84, 'S2',

if(Column(4) + 21 < 273, 'S3',

if(Column(4) + 21 >= 273 , 'S4', 'NA'

)

Or even simpler

if(Column(4) < 1, 'S1',

if(Column(4) < 63, 'S2',

if(Column(4) < 252, 'S3',

if(Column(4) >= 252 , 'S4', 'NA'

)