Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
vvvvvvizard
Partner - Specialist
Partner - Specialist

Ignore selection with Aggr

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)

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

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)

View solution in original post

4 Replies
nisha_rai
Creator II
Creator II

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

vvvvvvizard
Partner - Specialist
Partner - Specialist
Author

And to ignore the selection in the top expression? 

kavita25
Partner - Specialist
Partner - Specialist

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

sunny_talwar

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)