Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
saivina2920
Contributor

How do we count using multiple Conditions along with null value

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 ..?

Labels (2)
1 Solution

Accepted Solutions
Partner
Partner

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

 May be like this

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

  

2 Replies
Partner
Partner

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

 May be like this

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

  

saivina2920
Contributor

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

Excellent...It's working..