topic Re: Ignore selection with Aggr in QlikView

Ignore selection with Aggr

vvvvvvizard — Sat, 16 Nov 2024 01:14:41 GMT

How do add ignore selection field "Reconsiler" to this expression

Count( Aggr( nodistinct
if([Reviewer.RP_WorkDayNumber] - [Reviewer.Due_Date]>0,[Reviewer.RP_WorkDayNumber] - [Reviewer.Due_Date])
,[When Reviewer Attested]) )
+
Count({<AccountState={'Pending Reviewer'}>} AccNumber)

Re: Ignore selection with Aggr

nisha_rai — Thu, 20 Feb 2020 10:13:24 GMT

if you want to ignore the selection, use the below condition

Count({<AccountState={'Pending Reviewer'},Reconsiler=>} AccNumber)

it will ignore the Reconsiler field selection in count of Account Number

Re: Ignore selection with Aggr

vvvvvvizard — Thu, 27 Feb 2020 11:46:33 GMT

And to ignore the selection in the top expression?

Re: Ignore selection with Aggr

kavita25 — Thu, 27 Feb 2020 12:42:26 GMT

Try as below:

Count(Only({<Reconsiler>} Aggr( nodistinct
if(only({<Reconsiler>}[Reviewer.RP_WorkDayNumber] - [Reviewer.Due_Date])>0,[Reviewer.RP_WorkDayNumber] - [Reviewer.Due_Date])
,[When Reviewer Attested]) )
+
Count({<AccountState={'Pending Reviewer'},Reconsiler=>} AccNumber)

Regards,

Kavita

Re: Ignore selection with Aggr

sunny_talwar — Thu, 27 Feb 2020 13:24:28 GMT

May be this

Count({<Reconsiler>} Aggr(NODISTINCT Only({<Reconsiler>} RangeMax([Reviewer.RP_WorkDayNumber] - [Reviewer.Due_Date], 0)) , [When Reviewer Attested])) + Count({<AccountState = {'Pending Reviewer'}, Reconsiler>} AccNumber)