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: 
Anonymous
Not applicable

Expression - Excluded item

Hi All,

I need some help with the following expression where i want to exclude some "Name". However, when i try to tweet it to make it

more dynamic, it doesn't works.

First expression works if i hard coded the name
=sum({<[Type]={'Cost'},Name-={'Rick'}>}[Amount])

Second expression, i added a new column/Field called "Excluded" where value is either blank or "NA". If Excluded ="NA", exclude this from sum calculation. I expect Name field without "NA" with values and zeros for"NA".


=sum({<[Type]={'Cost'},Excluded-={'NA'}>}[Amount])

Many Thanks,

Frank

2 Replies
sunny_talwar

Why not assign a value (instead of null) when the Name doesn't have to excluded? Alternatively, you can try this

=Sum({<[Type]={'Cost'}, Name = {"=Len(Trim(Excluded)) = 0"}>}[Amount])

Assuming that Name will either have Excluded = N/A or Null (never both)

Anonymous
Not applicable
Author

Sunny,

I found alternative way of doing this. Your response was helpful. Thanks.