topic Re: Expresion in QlikView

Expresion

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

HI all,

Iam trying to write a expresion for the below given requirement ...please suggest if it is coorect

i have to take the coount of column A if there is null then it should take the count of Column B else Column A

count (isNull( A,B)A)

Please correct

devarasu07 — Thu, 24 Aug 2017 09:10:50 GMT

Try like below,

count(if(isnull(A),B,A))

IF(LEN(TRIM(A))<0,A,B)

tresB — Thu, 24 Aug 2017 09:12:00 GMT

Not sure what you are trying. The correct syntax would be: =Count( If(Isnull(A),B,A))

Kushal_Chawda — Thu, 24 Aug 2017 09:13:57 GMT

try this

=count(Alt(A,B))

tresB — Thu, 24 Aug 2017 09:17:05 GMT

Alt() would fail if A, B have non-numeric values.

tresB — Thu, 24 Aug 2017 09:20:12 GMT

IF(LEN(TRIM(A))<0,A,B) - len() never returns a negative value. I guess it's a typo. It would be '>'.

Kushal_Chawda — Thu, 24 Aug 2017 09:22:26 GMT

Yup, correct