last 02 days average

[ashraf_qlik]

Hi, I have sales for month for each day individually as per below data. (file attached, Sheet1 - data)

In report i want each day sum(sales) as per below, (file attached, sheet2 - report)

where Max date or last date - previous date/2,means, last day minus 02 days average.

for example, 06th june result will be 07 jun - 06 june sales /2 Please help how to do this

[HirisH_V7 · Accepted solution]

You can use something like this in UI expression,

Rangeavg(above(sum(Sales),0,2))

[ashraf_qlik]

Thanks

[HirisH_V7 · Accepted solution]

Please close the thread, if you got the answer. 🙂 like even.