topic Re: I'm baffled in QlikView

I'm baffled

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

This should be simple. I cannot see for the life of me what I am doing wrong.

I am trying to say

if(CVSS3 > CVSS, CVSS3,

if(CVSS3 = '', CVSS)) as Test

So if CVSS3 is greater than CVSS, give me CVSS3,

else if CVSS3 is blank give me the CVSS value

I cannot get the value if blank.

I've used NULL(), separated the equations and cannot get the blank value to return the other value.

Please advise.

Thanks

Anil_Babu_Samineni — Mon, 22 Oct 2018 10:04:27 GMT

May be second condition is not the really null value?

if(CVSS3 > CVSS, CVSS3, if(IsNull(CVSS3), CVSS)) as Test

if(CVSS3 > CVSS, CVSS3, if(Len(CVSS3)>0, CVSS)) as Test

bobbydave — Mon, 22 Oct 2018 10:23:10 GMT

I knew it was something simple.

THanks