Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
igdrazil
Contributor III

KPI max value and depending date

Hi there,

i got another problem. I have a KPI Value "Max(aggr(sum(pallets), time))" and for the second value on the same KPI i want the Date, when this value appears.

So e.g. max would be 15 and the date 1.1.2016.

I tried different things but it never worked... I am this far at the moment:

Max({$<Pallets = {'$(=Max(Aggr(Sum(Pallets), time)))'}>}time)

I think i may know the problem, which is that my part in {}-Brackets will give a sum and not a single Pallet number. Is there a way to filter for a sum in that part?

Thanks in advance!

Regards

Chris

1 Solution

Accepted Solutions
MVP
MVP

Re: KPI max value and depending date

FirstSortedValue(Time, -aggr(sum(pallets), time))

or

FirstSortedValue(Date, -aggr(sum(pallets), time))

2 Replies
MVP
MVP

Re: KPI max value and depending date

FirstSortedValue(Time, -aggr(sum(pallets), time))

or

FirstSortedValue(Date, -aggr(sum(pallets), time))

igdrazil
Contributor III

Re: KPI max value and depending date

Thank you! working fine and sooo much easier than my approach

Regards

Chris