Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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]))
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]))
Thank you! ^^