Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

set Analysis help

Hi Team ,

I am trying to count records  where price is 0 's or blank or nulls  . I used below expression but it just returns data with price 0. 

count({<PRICE ={0,' ' }>}distinct ORDER_ID)

how can I modify above expression to pull records for nulls and blanks rows too ?

5 Replies
Creator III
Creator III

Hi Arusanah
Can you please post sample records so that i can help you on this

Thanks
Kushal
Highlighted
Creator III
Creator III

Hi 

You can use the follwing Set Expression

 

=Count({<Price = {0}>+<Price = {''}>}OrderID)
+
Count({1-<Price = {"*"}>}OrderID)

 

I hope this answers your question

 

Thanks

Kushal

Highlighted
Master II
Master II

One way is as below:

=count({<PRICE ={0,"=Len(Price)=0" }>} distinct ORDER_ID)

Highlighted

Try this

Count({<ORDER_ID = {"=Sum(PRICE) = 0"}>} DISTINCT ORDER_ID)

or

Count({<PRICE ={0}>+<ORDER_ID = {"=Len(Trim(PRICE)) = 0"}>}DISTINCT ORDER_ID)

Highlighted

Or this

Count({<ORDER_ID = {"=Len(Trim(PRICE)) = 0 or PRICE = 0"}>} DISTINCT ORDER_ID)