Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

KPI objects - use other variable in filtering

Hi guys and girls,

In my spreadsheet I have a table which counts per weekday the the average open rate, click rate and the numbers of e-mails sent. Below the table I would like a wall of fame, which should contain the following KPI-items:

- Best weekday in terms of average open rate

- Best weekday in terms of average click rate

- Worst weekday in terms of average open rate

- Worst weekday in terms of average click rate

Could you help me going in coding the formula? I'm stuck for some time now and could really use some help. Thanks in advance!

Jeroen

0 Replies