QlikView App Dev

[Anonymous]

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

[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]

Sunny,

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