Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

Issue in set anlaysis exclude expression

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

1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

Re: Issue in set anlaysis exclude expression

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

{< Dimension = e(Dimension) >}

- Marcus