Set Analysis max qty date

rubenares — Fri, 22 Nov 2019 10:30:10 GMT

Working with the following dataset:

We want to get following result:

We are trying with following code:

Max Qty =

FirstSortedValue({<Date =>} Aggr(Sum({<Date =>} [Qty ]), Date ), -Aggr(Sum({<Date =>} [Qty ]), Date ))

Max Qty Date =

FirstSortedValue({<Date =>} Date , -Aggr(Sum({<Date =>} [Qty ]), Date ))

But we have problems with Max Qty Date measure because in case the max qty coincides on different dates, we want to show max of those dates.

Aditionally, these measures should ignore date selection.

Thanks in advance!

Re: Set Analysis max qty date

tresB — Fri, 22 Nov 2019 10:41:26 GMT

Hi,

It becomes easier for all to follow one thread. Please continue here : https://community.qlik.com/t5/Qlik-Sense-App-Development/Set-Analysis-sum-max-date-qty/m-p/1650001/highlight/false#M48485 with proper feedback/like or asking for clarification..