Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. 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
Highlighted
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)