topic Ignoring selection in QlikView

Ignoring selection

seahyanzheng — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Ignoring selection

Anil_Babu_Samineni — Wed, 10 Oct 2018 09:57:30 GMT

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]))

Re: Ignoring selection

seahyanzheng — Wed, 10 Oct 2018 10:01:27 GMT

Thank you! ^^