Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Brilliant!, Thanks Fabian