topic Re: Expression - Excluded item in QlikView

Expression - Excluded item

Anonymous — Thu, 16 Nov 2017 17:15:08 GMT

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

Re: Expression - Excluded item

sunny_talwar — Thu, 16 Nov 2017 17:17:44 GMT

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)

Re: Expression - Excluded item

Anonymous — Tue, 21 Nov 2017 15:35:58 GMT

Sunny,

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