topic Re: if statement with special characters in QlikView

if statement with special characters

Fri, 17 May 2013 09:30:18 GMT

Hello,

i not unterstand why the folling if statement produce a 'no' ,because a special character '-' more than space character like ' '?

if( '-' > ' ','yes','no')

result : no

Have anyone an idea what operation QlikView do in the bakground ?

Re: if statement with special characters

sushil353 — Fri, 17 May 2013 09:34:01 GMT

hi,

Use this:

=if( ord('-') > ord(' '),'yes','no')

HTH

Sushil

Re: if statement with special characters

Fri, 17 May 2013 09:39:56 GMT

Yes this works, but is this behaviour when i not use ord function normal in QlikView that '-' ist not more than ' ' ?

Re: if statement with special characters

sushil353 — Fri, 17 May 2013 09:57:18 GMT

- and ' ' is treated as character and you can not do greater than or less than of some character values... for this to happen you need to convert the chartacter value to corresponding numerical value..

that is why i have used ord() function.

Regards,

Sushil

Re: if statement with special characters

gaurav2017 — Fri, 17 May 2013 11:27:13 GMT

Dear,

please close the issues by marking the correct answer when the solution has been given as desired.

Regards

Gaurav

Re: if statement with special characters

peschu123 — Fri, 17 May 2013 11:57:47 GMT

Hi pkrolicki,

I assume there is another value in the field...

I tried the following and the result is always "YES".

tmp:

LOAD * INLINE [test,test2

'-',''];

TEST:

LOAD

//IF(test > test2,'YES','NO') AS bla // --> YES

IF(test > '','YES','NO') AS bla // --> YES

//IF(test > null(),'YES','NO') AS bla // --> NO

RESIDENT tmp;

Perhaps there is a difference between ' ' and '' ... the blank between the quotes. I don't know if you have a blank in your example. You could check this.

Hope it helps!

- PS -

Re: if statement with special characters

Fri, 17 May 2013 13:16:07 GMT

yes a blank is between the ' ' . I think the comparison beetween '-' and ' ' is for QV unlogical.

Re: if statement with special characters

peschu123 — Fri, 17 May 2013 13:27:41 GMT

Or a blank is > than '-' for QV ...is it necessary to have fields with a blank? In some cases this can be very confusing...? I think simple comparing(greater as..)of chars is unlogical at all..ok with abc you could do the ranking based on the alphabet etc. . And that a char is greater than no char could be logical too. But "minus" vs. "blank" ....

Perhaps the function chr() can help you in some situations...

Re: if statement with special characters

flipside — Fri, 17 May 2013 13:53:09 GMT

Could be QV is trying to resolve the '-' as a numerical negative rather than just hyphen. Consider this equation ...

=if('-0.6'>'-0.5',1,2) ... which returns 2.

Textually '-0.6' comes after '-0.5' but QV resolves the values to numbers and correctly calculates the numerical comparison where -0.6 is less than -0.5. If '-' is resolved as a number and the other value is text, they cannot be compared and cannot be true, therefore false.

Think only Qliktech could confirm.

flipside

Re: if statement with special characters

Fri, 17 May 2013 14:14:00 GMT

Yes it could be so but why the result for the following :

Load * Inline

'-'

' , '

' ' '

' " '

'{']

;

Load

if( a > ' ','yes','no'),

* resident 1;

is : no

yes

? It seems to be a logic behind it ...

Re: if statement with special characters

gaurav2017 — Fri, 17 May 2013 17:10:27 GMT

Hi,

Please refer to the attachment & do analysis by selecting the values.

is this what you wanted?

Regards,