topic Re: Is Null with Set Analysis in QlikView

Is Null with Set Analysis

jagjivvt — Fri, 12 Feb 2016 11:49:45 GMT

Hi,

I am using the following expression but it does not provide any result.

round(count({$<Region ={'(=isnull())'} >} distinct EmpNo) / count({$<EmpNo >} distinct EmpNo),0.01)

if I use a if statement the it does, but need to use set analysis.

count(DISTINCT(if(isnull(Region)=-1, EmpNo, null())))/count(DISTINCT(EmpNo))

thanks

Vijay

sunny_talwar — Fri, 12 Feb 2016 17:40:22 GMT

Try this:

Round(Count({$<Region ={"=IsNull(Region)"} >} Distinct EmpNo) / count({$<EmpNo >} Distinct EmpNo), 0.01)

Round(Count({$<Region ={"=Len(Trim(Region)) = 0"} >} Distinct EmpNo) / count({$<EmpNo >} Distinct EmpNo), 0.01)

jagjivvt — Mon, 15 Feb 2016 09:07:03 GMT

Hi Sunny,

thanks, but none of them give any result.

thanks

vijay

sunny_talwar — Mon, 15 Feb 2016 16:54:57 GMT

Would you be able to share a sample?