Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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¡