topic Re: Problem with set analysis- exclude in QlikView

Problem with set analysis- exclude

Tue, 28 Jul 2015 15:34:25 GMT

This is my expression:

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

It just works fine.

But when I just add one condition i.e., [RAL State] = {'TX'}. And exclude TX from my current selection, its not excluding TX in my expression.

SUM({<[Transaction ID]-={$(vTransactionIDsToExclude)}, $(vSecFilter),[RAL State]={'TX'}>
+
<[Transaction ID]={$(vTransactionIDtoInclude)},[RAL State]={'TX'}>}[SEC Amort Discounted Balance] )
+
sum({1< [Active Flag] = {'Active'}
, [Portfolio Code]={'1'}
, [Company Code]={'1'}
, [Region Code]={'60'}
, [SEC Amort Discounted Balance]={'>0'}
, [RAL State]={'TX'}
>}[SEC Amort Discounted Balance] )

Thanks in advance.

Regards,

Sachin

Re: Problem with set analysis- exclude

sunny_talwar — Tue, 28 Jul 2015 15:50:53 GMT

You want to exclude TX or include it from your selection?

Re: Problem with set analysis- exclude

Tue, 28 Jul 2015 15:53:43 GMT

Sorry, just include.

Re: Problem with set analysis- exclude

Tue, 28 Jul 2015 16:13:01 GMT

Sorry for the confusion Sunny.

I'm selecting TX in my set analysis but excluding it in my current selection.

Re: Problem with set analysis- exclude

ramoncova06 — Tue, 28 Jul 2015 17:16:38 GMT

you have two expressions what happens when you separate them, you are defining them as part of your set analysis so they will always show