Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
prma7799
Honored Contributor III

Handle with Nulls

Hi All,

I have one report in that i have calculated column say suppose "Output" (Column 35 ) and it is being calculated by (((Column(25))/Column(26))*Column(10))



In Output column i am getting some Null ( - ) values .

My expected output is instead of  this Null ( - ) I want Column(10) else (((Column(25))/Column(26))*Column(10))




Thanks

PM

1 Solution

Accepted Solutions

Re: Handle with Nulls

May be this

Alt((((Column(25))/Column(26))*Column(10)), Column(10))

View solution in original post

3 Replies

Re: Handle with Nulls

May be this

Alt((((Column(25))/Column(26))*Column(10)), Column(10))

View solution in original post

Highlighted

Re: Handle with Nulls

Not sure why you removed your response, but here is the explanation

Alt function picks the first non-null value in the order of expressions... so when (((Column(25))/Column(26))*Column(10)) is null, it picks Column(10)

Highlighted
prma7799
Honored Contributor III

Re: Handle with Nulls

Sorry it was by mistakenly deleted... In that I have written "Thanks Sunny.. Please explain little bit. "