Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
fanko1225
Contributor

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

Tags (1)
2 Replies

Re: Expression - Excluded item

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)

fanko1225
Contributor

Re: Expression - Excluded item

Sunny,

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