Issue in set anlaysis exclude expression

Wed, 22 Jul 2015 20:45:27 GMT

Hi,

Below is my set analysis expression which works perfectly fine.

[Disc. Bal.]

/
SUM({< [Transaction ID]-={$(vTransactionIDsToExclude)}
, $(vSecFilter)
>
+
<[Transaction ID]={$(vTransactionIDtoInclude)}>
+
< [Active Flag] = {'Active'}
, [Portfolio Code]={'1'}
, [Company Code]={'1'}
, [Region Code]={'60'}>

} TOTAL( [SEC Amort Discounted Balance]))

But I now have a new requirement to exclude current selection. So I added '1' but now I'm getting very wierd results. Can anyone explain me the issue in my expression

[Disc. Bal.]

/
SUM({< [Transaction ID]-={$(vTransactionIDsToExclude)}
, $(vSecFilter)
>
+
<[Transaction ID]={$(vTransactionIDtoInclude)}>} TOTAL( [SEC Amort Discounted Balance]))

+
sum({1 < [Active Flag] = {'Active'}
, [Portfolio Code]={'1'}
, [Company Code]={'1'}
, [Region Code]={'60'}>

} TOTAL( [SEC Amort Discounted Balance]))

Regards,

Sachin

Re: Issue in set anlaysis exclude expression

marcus_sommer — Thu, 23 Jul 2015 11:19:57 GMT

You could try it with 1- or you extend your set analysis statement to some E() functions:

{< Dimension = e(Dimension) >}

- Marcus

topic Issue in set anlaysis exclude expression in QlikView

Issue in set anlaysis exclude expression

Re: Issue in set anlaysis exclude expression