Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Rapunzel2022
Contributor
Contributor

count Null expression

customer customer_type
a 11
b 12
c 13
d  
e aa
f bb
g cc
h 11
i bb
j 13
k aa

 

Hi,

I need your help 🙂
I have a table like this example.

Customer d has no customer type (null)

I need a view or count without Customer type 11
=count({<[customer_type]-={'11'}>}[Customer]

I need a table only without 11 like

customer customer type
b 12
c 13
d  
e aa
f bb
g cc
i bb
j 13
k aa

 

When I have a diagramm the count for Customer must be 9 (including the customer with Null expression.

How can I do it?

Thanx

2 Replies
hic
Former Employee
Former Employee

=count({<customer=E({<customer_type={'11'}>})>} customer)

Rapunzel2022
Contributor
Contributor
Author

Thanx