Need a KPI to pull the maximum value from a chart

[Bird_za]

Hello, very new to Qlik.

I've got a chart measuring a Rolling 31 days sales, with the measure : 

sum({$<Date={">=$(=Date(vLastMonth))<=$(=Date(vToday))"} >} Sales)

I would just like to know if it where possible to to add a KPI that displays the date with the highest sales value as well as the corresponding value for the rolling 31.

[QFabian · Accepted solution]

Hi @Bird_za , please check this example.

Create a new Variable:

vMaxSales = max({$<Date={">=$(=Date(vLastMonth))<=$(=Date(vToday))"} >} Sales)

And then use this expression, it just includes an IF statement.

max({$<Date={">=$(=Date(vLastMonth))<=$(=Date(vToday))"} >} if(Sales = $(vMaxSales), Date))

In Set analysis, you can use "Expression searches", but the formula gets more complex.

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalys...

[Bird_za]

Brilliant!, Thanks Fabian