Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
monica
Contributor
Contributor

Hourly Max per day

Good day

I am new and I am stuck.I have a data set that has different sales figures per hour as shown below.I would like to show the maximum sales figure on a KPI. May you please help with an expression.Thank you in advance.

qlik.PNG

3 Replies
JordyWegman
Partner - Master
Partner - Master

Hi Monica,

Is it the maximum sales figure for the total data set? Or for each hour?

Use this code if you want the maximum sales for the complete data set:

Max(Sales)

Jordy,

Climber

Work smarter, not harder
monica
Contributor
Contributor
Author

Hi Jordy

I want to get the maximum sales for the previous 18/03/2019.I want it to automatically update.I have made some amendments to the data setqlik.PNG.

JordyWegman
Partner - Master
Partner - Master

Hi Monica,

If you want to know the max from the day before you should do the following things.

1. First get to know the maximum date and subtract one from it

Load
Max(Date)-1 as MaxPreviousDate
From (Your source);

 

2. Get this date in set analysis in your Max(Sales) formula (this is a front-end formula)

Max({$< Date = {"$(MaxPreviousDate)"}>}Sales)

 

Then you have your KPI value.

Jordy

Climber

Work smarter, not harder