topic Expression problem in QlikView

Expression problem

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

Dear All

I have a table looks like this :

I can get cities whose value is all 0 by using "=Concat(DISTINCT{<Value={0}>} City ,',')",it will return "Chongqing,Nanjing"

but how to get cities whose value is all NULL ? , I need a expression, in my case , should return "Shanghai,Heibei"

thanks

sunny_talwar — Fri, 28 Apr 2017 13:45:34 GMT

May be this

=Concat(DISTINCT{<City = {"=Sum(Value) = 0"}>} City ,',')

antoniotiman — Fri, 28 Apr 2017 14:11:06 GMT

Try

=Concat({<City={"=Sum(Value)=0"}>-<Value={0}>} DISTINCT City,';')

Regards,

Antonio

sunny_talwar — Fri, 28 Apr 2017 14:15:47 GMT

Or just this to get two Cities

=Concat(DISTINCT{<City = {"=Sum(Value) = 0 and Value <> 0"}>} City ,',')

woshua5550 — Fri, 28 Apr 2017 17:20:57 GMT

Awesome

woshua5550 — Fri, 28 Apr 2017 17:22:14 GMT

Both very nice , thx a lot