Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to discard some fields to make count?

Hi Everybody

I have a table like this:

ID
ID Padre
IM23456
IM26788
IM74777IM78789
IM34677
IM98789
IM44323IM98767

The idea is to count and show in a graphic only the elements in ID field that don´t have any data in ID Padre field, for the example would be 4 ID because i have 2 Items with data in ID Padre field.

How can i make this?

1 Solution

Accepted Solutions
johnw
Champion III
Champion III

Maybe this?

count(if(len("ID Padre")=0,ID))

View solution in original post

2 Replies
johnw
Champion III
Champion III

Maybe this?

count(if(len("ID Padre")=0,ID))

Not applicable
Author

!Thanks for your great help¡