Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
richardouellett
Creator
Creator

Filter Chart Expression Sum(If(Name='J*',1,0) Doesn't Work?

Good Morning

I have a simple chart with 1 expression above trying to tabulate 1st name counts based on the 1st Initial; typical 1st name fields are  John, Jane, Susan, Linda, Richard etc.  Can you suggest work around?  I also need to filter using Sum(If(Name<>'J*',1,0).

As an FYI Sum(If(Name Like 'J*',1,0) works but I  still would not have a solution for Sum(If(Name<>'J*',1,0).

Thank!

Rick

1 Reply
swuehl
MVP
MVP

Please don't post the same request multiple times, and also please post it to places with an appropriate scope (QDF probably is not a place with a correct sope)

Filter Chart Expression Sum(If(Name='J*',1,0) Doesn't Work?