topic Re: How do we count using multiple Conditions along with null value in QlikView

How do we count using multiple Conditions along with null value

saivina2920 — Sat, 16 Nov 2024 04:07:27 GMT

How do we count using multiple Conditions along with null value ..?

For Example,

I am counting null value and my expression is below.

1st Expression ==> =Count(If(Len(Trim([Sales]))=0,[Sales]))

with the above, i just want to check two more condition as mentioned below.

2nd Expression ==> ({<[Current Status] = {'*ISSUE FOR CHECK*'}>} DISTINCT [PRODUCT ID NUMBER])

How do we combine 1st and 2nd expression. It means How do we count using multiple Conditions along with null value ..?

raman_rastogi — Tue, 19 Mar 2019 06:45:22 GMT

May be like this

Count({<[Sales]= {"=len(trim([Sales])) =0"},[Current Status] = {"*ISSUE FOR CHECK*"}>} DISTINCT [PRODUCT ID NUMBER])

saivina2920 — Tue, 19 Mar 2019 06:54:38 GMT

Excellent...It's working..