Ignoring selection

[seahyanzheng]

Hi Qlikview community,

May i ask why Salesperson and Sales Emp ID is not getting ignored as it should be:

= FirstSortedValue(

Salesperson,-aggr(count({$<ACCEPTANCE_DTTM={"*"}, [Salesperson]=,[Sales Emp ID]=,[Sales Team 1]=,%ProcessingType={'Acceptance'},

%BaseType={'Acceptance'},HL_TL_IND={1}>} [CASE_NUM]),[Sales Emp ID]))

Thanks!

[Anil_Babu_Samineni · Accepted solution]

Try this way?

= FirstSortedValue(

{$<ACCEPTANCE_DTTM={"*"}, [Salesperson]=,[Sales Emp ID]=,[Sales Team 1]=,%ProcessingType={'Acceptance'}, %BaseType={'Acceptance'},HL_TL_IND={1}>}

Salesperson,-aggr(count({$<ACCEPTANCE_DTTM={"*"}, [Salesperson]=,[Sales Emp ID]=,[Sales Team 1]=,%ProcessingType={'Acceptance'},

%BaseType={'Acceptance'},HL_TL_IND={1}>} [CASE_NUM]),[Sales Emp ID]))

[seahyanzheng]

Thank you! ^^