Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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